How to Export data, of a DataSet to an Excel File

swadhinm · May 24th, 2005, 02:45 AM

Hi Friends,

How are you all? Hope you all are doing well. I am doing an ASP.NET project with C#. I have to export the data of a DataSet to an EXCEL file.

Please give me the code example of C# on that.

Thanks,

Regards,

Swadhin.

r_ganesh76 · May 24th, 2005, 06:57 AM

You can load a datagrid with the dataset and then call the RenderControl method to export it to Excel. I am not sure how to export directly from a dataset. I normally do this way

Regards
Ganesh

swadhinm · May 24th, 2005, 08:02 AM

Hi Ganesh,

You have said that I can call ReaderControl method to export data to excel in ASP.NET project with C#. Can you give me code example on that?

Thanks,

Regards,

Swadhin.

r_ganesh76 · May 24th, 2005, 11:00 PM

1st you have to bind the grid with data

Code:

Response.Clear(); 
Response.Buffer = true; 
Response.ContentType = "application/vnd.ms-excel"; 
Response.Charset = ""; 
EnableViewState = false; 
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); 
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); 

grdSrcRequestExport.RenderControl(oHtmlTextWriter); 

Response.Write(oStringWriter.ToString()); 
Response.End();

Regards
Ganesh

swadhinm · May 24th, 2005, 11:55 PM

Hi Ganesh,

Thanks, Thanks a lot.

Regards,

Swadhin.

r_ganesh76 · May 25th, 2005, 11:11 PM

Cheers Swadhin

Sometimes you may need to assign the values in the template columns to the column so that all columns are exported correctly

Regards
Ganesh