ASP.NET Export DataGrid To Excel

Its Very easy to Export DataGrid to Excel. First you populate DataGrid and add following code to export datagrid data to excel. Here datagrid object is 'dgBillDetails'.

---

Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
DataGrid1.VirtualItemCount = 0;
DataGrid1.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();

---