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

swadhinm · #1 (**permalink**) 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 · #2 (**permalink**) 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 · #3 (**permalink**) 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 · #4 (**permalink**) 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 · #5 (**permalink**) May 24th, 2005, 11:55 PM

Hi Ganesh,

Thanks, Thanks a lot.

Regards,

Swadhin.

r_ganesh76 · #6 (**permalink**) 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

Need to download code?

Navigation