protected void btnExportToExcel_Click(object sender, EventArgs e) { ClsExporttoExcel objExportToExcel = new ClsExporttoExcel(); DataSet ds = new DataSet(); binddata(true, out ds, txtFromDate.Text, txtToDate.Text); Response.AddHeader("Content-Disposition", "attachment;filename=ComplaintReport.xls"); GvDetails.AllowPaging = false; objExportToExcel.Convert(ds, Response, GvDetails); GvDetails.AllowPaging = true; }
protected void btnExportExcel_Click(object sender, EventArgs e) { DataSet ds = Session["DsDefect"] as DataSet; if (ds != null) { ClsExporttoExcel objExportToExcel = new ClsExporttoExcel(); GridView1.AllowPaging = false; Response.AddHeader("Content-Disposition", "attachment;filename=ComplaintReport.xls"); objExportToExcel.Convert(ds, Response, GridView1); GridView1.AllowPaging = true; Session["DsDefect"] = null; } }