Export To Excel for DataSet

#region
//public static void ExportToExcel1(DataTable dt,string fileName,HttpResponse response)
public static void ExportToExcel1(DataTable dt,HttpResponse response)
{
response.Clear();
//response.AddHeader("content-disposition", "attachment;filename="+ fileName + ".xls");
response.AddHeader("content-disposition", "attachment;filename=File1.xls");
//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 System.Web.UI.HtmlTextWriter(stringWrite);
DataGrid dg = new DataGrid();
dg.DataSource = dt;
dg.DataBind();
dg.RenderControl(htmlWrite);
response.Write(stringWrite.ToString());
response.End();
}
#endregion