System.Web.UI.WebControls.DataGrid dg = new System.Web.UI.WebControls.DataGrid; try { Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=ExportFile.xls"); EnableViewState = true; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite); dg = new System.Web.UI.WebControls.DataGrid(); dg.DataSource = ds; dg.DataBind(); dg.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); } catch (Exception ex) { Response.Write(ex.Message); } finally { }