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;
    }
Esempio n. 2
0
    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;
        }
    }