xml and csv with ado.net

[knightsurfer]

Hello everybody out there,

I got a problem with a db-format, the metadata is written in XML (such
things like tables names, paths, fieldnames and delimiter etc.), the
data is written in .csv-files. How can I put this two thinmgs together
in one dataset?

Thanx

Lars

 

[William Ryan eMVP]

You can use DataSet.ReadXML to read in the schema data. Then use the .OleDb
library to read in teh csv There's an example of using the OleDb connection
to connect to a .csv file over at www.connectionstrings.com

HTH,

Bill

--
W.G. Ryan MVP Windows - Embedded

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups