protected void btmExport_Click(object sender, EventArgs e) { //Response.Redirect("DownloadComplaintsExcel.aspx"); DataSet ds = (DataSet)ViewState["ComplaintDataSet"]; ExportDetails(ds.Tables[0]); } public void ExportDetails(DataTable dt) { string fileName = "Complaints-" + DateTime.Today.Day.ToString() + "" + DateTime.Today.Month.ToString() + "" + DateTime.Today.Year.ToString(); HttpResponse response = HttpContext.Current.Response; response.Clear(); response.ContentType = "application/vnd.ms-excel"; response.AddHeader("Content-Disposition", "attachment;filename=\"" + fileName + "\".xls"); StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = dt; dg.DataBind(); dg.RenderControl(htw); response.Write(sw.ToString()); response.End(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)