Export Data from GridView to Excel in ASP.NET using C#

/*If the GridView is not under a form tag which run at server*/

private void ExportGridView()

{

Response.Clear();

Response.AddHeader("content-disposition", "attachment;filename= Result.xls");

Response.Charset = "";

Response.ContentType = "application/vnd.xls";

StringWriter stringWrite = new StringWriter();

HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

HtmlForm frm = new HtmlForm();

GridView1.Parent.Controls.Add(frm);

frm.Attributes["runat"] = "server";

frm.Controls.Add(GridView1);

frm.RenderControl(htmlWrite);

Response.Write(stringWrite);

Response.End();

}

/*If the GridView is under a form tag which run at server*/

private void ExportGridView()

{

Response.Clear();

Response.AddHeader("content-disposition", "attachment;filename= Result.xls");

Response.Charset = "";

Response.ContentType = "application/vnd.xls";

StringWriter stringWrite = new StringWriter();

HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

GridView1. RenderControl(htmlWrite);

Response.Write(stringWrite);

Response.End();

}