public void csExportToExcel(System.Web.UI.WebControls.DataGrid gridDownload,System.Data.DataSet lds, System.Web.HttpResponse Response,Page myPage, string fileName) ... { gridDownload.DataSource = lds; gridDownload.DataBind(); Response.Clear(); Response.Buffer = true; Response.ContentType="application/vnd.ms-excel"; Response.AddHeader("Content-disposition", "attachment; filename="+fileName+".xls"); Response.ContentEncoding=System.Text.Encoding.Default; Response.Charset=""; myPage.EnableViewState = false; StringWriter SW = new StringWriter(); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); gridDownload.AllowPaging = false; gridDownload.RenderControl(htmlTW); Response.Write(SW.ToString()); Response.End(); }