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°ÑÊý¾Ý·µ»Ø¸ø¿Í»§¶Ë£¬