Load XML file into DataTable (not from a Database)

Question

I'm looking into changing my application to load its xml format data files into DataTables (and a DataSet?) instead of deserializing them into classes. I can generate a dataset using xsd.exe, but I'm not having any luck finding any examples showing how to use it.

My Google searches have been hopelessly clogged with examples using xsd files as an intermediary in accessing database tables. Since my apps saving data files instead of querying a DB these aren't of any use to me.

Saar · Accepted Answer · 2009-12-07 16:14:53Z

6

Try out with. May be you need to format your xml.

    DataSet ds = new DataSet();
    ds.ReadXml("xml file path");

answered Dec 7, 2009 at 16:14

Saar

8,5245 gold badges33 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dan Is Fiddling By Firelight Over a year ago

Don't ask me how I failed to find that method with intelisense. I hate Mondays.

marc_s Over a year ago

Say Dan - how did you miss that obvious function, even with Intellisense?? (sorry, just couldn't resist <evil grin>)

Webleeuw · Accepted Answer · 2009-12-07 16:15:18Z

3

Is manually filling the schema and table an option?

DataTable table = new DataTable();
table.ReadXmlSchema(xmlReader);
table.ReadXml(xmlReader);

answered Dec 7, 2009 at 16:15

Webleeuw

7,30036 silver badges35 bronze badges

Collectives™ on Stack Overflow

Load XML file into DataTable (not from a Database)

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related