asp.net ÈçºÎµ¼ÈëExcel±í¸ñ£¿
asp.net ÈçºÎµ¼ÈëExcel±í¸ñ£¿
ÓÃOleDbConnection¿ÉÒÔ°Ñexcelµ±³ÉÊý¾Ý¿âÒ»Ñù¶Á½üÀ´
ÓÐÀý³ÌÂð£¿
/// <summary>
/// µ¼Excel
/// </summary>
/// <param name="FileType"> </param>
/// <param name="FileName"> </param>
private void Export(string FileType, string FileName)
{
//Çå³þ·ÖÒ³
if (this.RadioButton1.Checked == true)
{
GridView1.AllowPaging = false;
}
if (this.RadioButton2.Checked == true)
{
GridView2.AllowPaging = false;
}
if (Session["btn"] == null)
{
PopulatePublishersGridView();
}
else
{
Session["type"] = "o";
BtnGridView();
}
&n
Ïà¹ØÎÊ´ð£º
ASP.NET MVC¼Ü¹¹·¢²¼ÁË,ÄãÓÃÁËÂð£¿
»¹ÔÚѧϰÖÐ
ÎÒÒ²ÔÚѧϰ¡£ÂòÊ飬Ìý½Ì³Ì£¬¿´ÍøÉÏ×ÊÁÏ£¬ÏÂÔØÀý×Ó£¬¸Ð¾õÌý²»´íµÄ£¬²»¹ý±ÈÆð¹¤³§Ä£Ê½£¬ËƺõÑ·É«Á˵㡣¡£¡£»¶Óµ½ÎÒ²©¿Í»¥Ïàѧϰ
¶¼ÓÃÁË5¸ö°æ±¾ÁË ´Ó PV1 µ½beta ......
֮ǰÓöµ½Ò»¸öÎÊÌâ¡£
ÓÚÊÇ×öÁËÒÔÏÂʵÑ飺
Ò³Ãæ¼ÓÔØºó£¬Ìá½»Ò»¸öAjaxÇëÇó(ÔݳÆÎªajax1)£¬ÇëÇóµÄÏß³ÌÔÚ·þÎñÆ÷Éϱ»Ë¯Ãß10ÃëÖÓ¡£
µã»÷Ò³ÃæÉÏÒ»¸öbutton£¬´¥·¢ÁíÒ»¸öAjaxÇëÇó(ajax2)¡£
µ±Ã»ÓÐʹÓÃsession£¬ÔÚ·þÎñÆ÷δ´ ......
±¾ÈËĿǰÓöµ½Ò»¸öÄÑÌ⣬Çë¸÷λ¸ßÊÖ¡¢´óÏÀ°ï°ïæ¡£
ÎÒµ¥»÷Ò»¸ö°´Å¥Ê±Òª°ÑgridviewÖеÄÊý¾ÝÒ»¸öÒ»¸öµÄÈ¡³ö²¢°Ñ¶ÔÓ¦²ÎÊý´«µÝ¸øÇ°Ì¨µÄjs¡£
ÎÒÊÔÁ˼¸ÖÖºǫ́µ÷ǰ̨µÄ·½Ê½¶¼Ã»Óгɹ¦£¬ËùÒÔÇë´óÏÀÃǰï°ïСµÜ¡£
лл¡£
²» ......
CREATE PROCEDURE [selectvipcompany]
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql='' ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......