How to export 1 million records into excel from datatable on button click

See more:

Javascript

.NET

ASP.NET4

Hello guys,

I want to get data from database and export it into excel on button click.There can be more than 2 lacs records in datatable.My code is working fine but it's taking 5 minutes to export data in excel.So its very slow in performance thats main issue for me.

I tried below code:

public void Export()
      {
          Response.Clear();
          Response.Buffer = true;
          Response.AddHeader("content-disposition", "attachment;filename=Summary.xls");
          Response.Charset = "";
          Response.ContentType = "application/vnd.ms-excel";
          using (StringWriter sw = new StringWriter())
          {
              HtmlTextWriter hw = new HtmlTextWriter(sw);

              //To Export all pages
              GVExport.AllowPaging = false;
             // this.BindGrid();

              GVExport.HeaderRow.BackColor = Color.White;
              foreach (TableCell cell in GVExport.HeaderRow.Cells)
              {
                  cell.BackColor = GVExport.HeaderStyle.BackColor;
              }
              foreach (GridViewRow row in GVExport.Rows)
              {
                  row.BackColor = Color.White;
                  foreach (TableCell cell in row.Cells)
                  {
                      if (row.RowIndex % 2 == 0)
                      {
                          cell.BackColor = GVExport.AlternatingRowStyle.BackColor;
                      }
                      else
                      {
                          cell.BackColor = GVExport.RowStyle.BackColor;
                      }

                  }
              }

              GVExport.RenderControl(hw);

              //style to format numbers to string
             // string style = @"<style> .textmode { } </style>";
             // Response.Write();
              Response.Output.Write(sw.ToString());
              Response.Flush();
              Response.End();
          }

Please let me know if you have better approach to do this.

Thanks and regards
Rahul