converting dataset to excel ..

[Guest]

please give me tips or code to convert a dataset to excel sheet

 

[W.G. Ryan eMVP]

You can use a OleDbDataAdapter http://www.connectionstrings.com/ (Look for
Excel) and then just call Update. Otherwise, you're going to have to use
the Excel Library and walk the sheet, populating a dataset from there. It's
not very complex, just two loops, if you don't know the excel object model
it'sa pain inthe butt. here's an example
http://www.codeproject.com/dotnet/ExportExcelData.asp However if you put in
Excel to DataSet in google, there's quite a few more that are pretty much
ready to go.

HTH,

Bill

 

[Bernie Yaeger]

Hi Venkat,

I Bill got your request backwards - you want to go from dataset to excel,
not the reverse. Here's a good example:

http://www.dotnetspider.com/technology/kbpages/950.aspx

HTH,

Bernie Yaeger