1 private void toExcel(DataTable tb)
2 {
3     System.Web.UI.WebControls.DataGrid dgrid = null;
4     System.Web.HttpContext context = System.Web.HttpContext.Current;
5     System.IO.StringWriter strOur = null;
6     System.Web.UI.HtmlTextWriter htmlWriter = null;
7     if ((tb != null)) {
8         context.Response.ContentType = "application/vnd.ms-excel ";
9         context.Response.ContentEncoding = System.Text.Encoding.UTF8;
10         context.Response.Charset = " ";
11
12         strOur = new IO.StringWriter();
13         htmlWriter = new System.Web.UI.HtmlTextWriter(strOur);
14         dgrid = new DataGrid();
15         dgrid.DataSource = tb.DefaultView;
16         dgrid.AllowPaging = false;
17         dgrid.DataBind();
18
19         dgrid.RenderControl(htmlWriter);
20         context.Response.Write(strOur.ToString);
21         context.Response.End();
22     }
23 }