ASP.NET with C# and SQL SERVER , some vb.net . asp.net examples, asp.net codes, asp.net programs, c# code, sql server queries, important codes.
Thursday, 18 October 2012
export data from dataset to excel
using System;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.UI.WebControls;
using System.IO;
namespace ExcelUtility
{
/// <summary>
/// Summary description for DataSetToExcel
/// </summary>
public class DataSetToExcel
{
public DataSetToExcel()
{
//
// TODO: Add constructor logic here
//
}
public static void Convert( DataSet ds, HttpResponse Response)
{
Response.Clear();
Response.Charset="";
Response.ContentType="application/vnd.ms-excel";
System.IO.StringWriter stringWrite=new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite=new System.Web.UI.HtmlTextWriter(stringWrite) ;
System.Web.UI.WebControls.GridView dg=new System.Web.UI.WebControls.GridView();
dg.DataSource = ds.Tables[0];
dg.DataBind();
dg.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
}
}
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment