Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASP.NET(C#) DataSetÊý¾Ýµ¼³öµ½Excel

½ñÌì¸ø¿Í»§×öÁ˸ö¹¦ÄÜÐèÒª°ÑÍø¸ñÊý¾Ý£¨Gridview£©µ¼³ö³ÉExecl£¬ËùÒÔÎÒÈ¥ÍøÉÏÕÒÁ˸ö´úÂë private void Export(string FileType, string FileName)
...{
try
...{
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
grdSearch.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}
catch (Exception err)
...{
DOMUtility.PopAlertWindow("µ¼³öExcel³ö´í£¡´íÎóÔ­Òò£º" + err.Message);
//return false;
}
}
µ«ÊÇÕâÖÖ·½·¨µÄ»°Ö»Êǰѵ±Ç°GridviewÒ³µ¼³öµ½Excel£¬¶ø¿Í»§ÐèÒª°Ñµ±Ç°ËùÒÔ·ÖÒ³µÄÊý¾Ýµ¼³öµ½Excel£¬²¢ÇÒÔÚ¿Í»§¶Ë´ò¿ª£¬ËùÒÔÏëÁËÏëÓм¸ÖÖ·½°¸£º
1£©½«execlÎļþµ¼³öµ½·þÎñÆ÷ÉÏ£¬ÔÙÏÂÔØ¡£ÕâÑùµÄ»°·þÎñÆ÷ÖÐÓжàÓàµÄÎļþÁË¡£²»Í¨¹ý
2£©½«DataSetÖеÄÊý¾Ýµ¼³öExecl
private void DataTable2Excel(System.Data.DataTable dtData)
...{
System.Web.UI.WebControls.DataGrid dgExport = null;
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;

if (dtData != null)
...{
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
curContext.Response.Charset = "";

strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);

dgExport = new System.Web.UI.WebControls.DataGrid();
dgExport.DataSource = dtData.DefaultView;
dgExport.AllowPaging = false;
dgExport.DataBind();

dgExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.End();
}
}
ÏȰÑdatatableת»»³ÉDataGridÊý¾Ý£¬È»ºóͨ¹ýDataGrid¶ÔÏóRenderControlµÄResponse°ÑÊý¾Ý·µ»Ø¸ø¿Í»§¶Ë£¬


Ïà¹ØÎĵµ£º

C#: ÌáÈ¡ÍøÒ³ÖеÄjavascript´úÂë

public static void Main()
        {
            WebRequest req = WebRequest.Create("http://blog.csdn.net/xiaofengsheng");
            try
  & ......

asp.net Ò³ÃæÌø×ªµÄ¼¸ÖÖ·½·¨

 
1 response.redirect Õâ¸öÌø×ªÒ³ÃæµÄ·½·¨Ìø×ªµÄËٶȲ»¿ì£¬ÒòΪËüÒª×ß2¸öÀ´»Ø£¨2´Îpostback£©£¬µ«Ëû¿ÉÒÔÌø תµ½ÈκÎÒ³Ãæ£¬Ã»ÓÐÕ¾µãÒ³ÃæÏÞÖÆ£¨¼´¿ÉÒÔÓÉÑÅ»¢Ìøµ½ÐÂÀË£©£¬Í¬Ê±²»ÄÜÌø¹ýµÇ¼±£»¤¡£µ«ËÙ¶ÈÂýÊÇÆä×î´óȱÏÝ£¡redirectÌø×ª»úÖÆ£ºÊ×ÏÈÊÇ·¢ËÍÒ»¸öhttpÇëÇ󵽿ͻ§¶Ë£¬Í¨ÖªÐèÒªÌø×ªµ½ÐÂÒ³Ãæ£¬È»ºó¿Í»§¶ËÔÚ·¢ËÍÌø×ª ......

ѧϰasp.net C#

 1¡¢DateTime   Êý×ÖÐÍ  
System.DateTime   currentTime=new   System.DateTime();  
¡¡¡¡1.1   È¡µ±Ç°ÄêÔÂÈÕʱ·ÖÃë  
currentTime=System.DateTime.Now;  
¡¡¡¡1.2   È¡µ±Ç°Äê  
int   Äê=currentTime.Year;  
¡¡¡¡1.3   È¡µ±Ç°Ô &n ......

ASP.NET Ò³ÃæÖ¸Áî Ö® @OutputCache

»º´æµÄÖØÒªÐԾͲ»ÓÃÔÙÇ¿µ÷ÁË£¬@OutputCache¸øÎÒÃÇÌṩÁËÒ»ÖÖÉùÃ÷µÄ·½Ê½(¶ÔÓ¦µÄ»¹Óбà³ÌµÄ·½Ê½)À´¿ØÖÆÒ³ÃæºÍÓû§¿Ø¼þµÄ»º´æ²ßÂÔ£¬ÕâÊÇÒ»ÖÖ×î¼òµ¥Ö±½ÓµÄÍøÕ¾ÓÅ»¯·½Ê½¡£
»¹ÊÇÏÈÀ´¹ýÒ»±é@OutpuCacheËùÓеÄÊôÐÔ£¬¹²ÓÃ11¸öÊôÐÔ£¬Õâ¸öÖ¸Áî¿ÉÒÔÓÃÓÚÒ³Ãæ(.aspx)ºÍÓû§¿Ø¼þ(.ascx)
ÊôÐÔ
Duration
Ò³»òÓû§¿Ø¼þ½øÐлº´æµÄʱ¼ä£¬µ¥Î ......

asp.netµÄ»º´æ»úÖÆ

»º´æÊǰÑÓ¦ÓóÌÐòÖеÄÐèҪƵ·±¡¢¿ìËÙ·ÃÎʵÄÊý¾Ý±£´æÔÚÄÚ´æÖеıà³Ì¼¼Êõ£¬Í¨³£ÓÃÀ´Ìá¸ßÍøÂçµÄÏìÓ¦ËÙ¶È¡£ÔÚASP.NETÖÐʹÓÃCacheÀàÀ´¹ÜÀí»º´æ¡£ÏÂÃæÏêÊö¿Ø¼þ¼¶Êý¾Ý»º´æ¹¦ÄܺÍÒ³Ãæ¼¶Êý¾Ý»º´æ¹¦ÄܵÄʵÏÖ£º
(1)Êý¾Ý¿â»º´æÒÀÀµ
Êý¾Ý¿â»º´æÒÀÀµÓÉSqlCacheDependencyÀà¹ÜÀí£»
Êý¾Ý¿â»º´æÒÀÀµµÄÓŵ㣺
1¡¢Ìá¸ßÊý¾Ý³ÊÏÖËÙ¶È£¬Ã¿´Î»ñ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ