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();
        }
    }
}

No comments:

Post a Comment