Exporting data from datagrid to excel sheet

Refer Our recommended articles...

Hi,

Add Namespaces First

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Text;
using Microsoft.Practices.EnterpriseLibrary.Data;

//and code to export Datagrid to Excel File

Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls"); //Give Excel File Name
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
myDataGrid.RenderControl(htmlWrite);  // Give DataGrid Name Here
Response.Write(stringWrite.ToString());
Response.End();


--------------------------------------------
If this post helps you, then mark as "Correct Answer"
Thank you