G
Guest
What is the most efficient way of transforming DataSet to excel spreadsheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
W.G. Ryan eMVP
Fill the dataset with a DataAdapter setting the AcceptChangesDuringFill to
false. Then use the OleDbDataAdapter to Update it - the connection string
is available at http://www.connectionstrings.com/ under the Excel section.
You can also use the WriteXML method and then use Com INterop to pull it in.
HTH,
Bill
--
W.G. Ryan, MVP
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
false. Then use the OleDbDataAdapter to Update it - the connection string
is available at http://www.connectionstrings.com/ under the Excel section.
You can also use the WriteXML method and then use Com INterop to pull it in.
HTH,
Bill
--
W.G. Ryan, MVP
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
spreadsheet?Pankaj Banga said:What is the most efficient way of transforming DataSet to excel
G
Guest
Hi Ryan
the link u hv posted is not working.
the link u hv posted is not working.
W.G. Ryan eMVP said:Fill the dataset with a DataAdapter setting the AcceptChangesDuringFill to
false. Then use the OleDbDataAdapter to Update it - the connection string
is available at http://www.connectionstrings.com/ under the Excel section.
You can also use the WriteXML method and then use Com INterop to pull it in.
HTH,
Bill
--
W.G. Ryan, MVP
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
spreadsheet?
W
W.G. Ryan eMVP
I just tried it and it's up now. Give it another try...