Excel export from grid view
20/08/2012 18:27
if (GridView2.Rows.Count + 1 < 65536)
{
GridView2.AllowPaging = false;
GridView2.DataBind();
StringWriter tw = new StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
HtmlForm frm = new HtmlForm();
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename= Filename.xls");
Response.Charset = "";
EnableViewState = false;
Controls.Add(frm);
frm.Controls.Add(GridView2);
frm.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
GridView2.AllowPaging = true;
GridView2.DataBind();
}