C# XMLDocument to DataTable?

Question

I assume I have to do this via a DataSet, but it doesn't like my syntax.

I have an XMLDocument called "XmlDocument xmlAPDP".

I want it in a DataTable called "DataTable dtAPDP".

I also have a DataSet called "DataSet dsAPDP".

-

if I do DataSet dsAPDP.ReadXML(xmlAPDP) it doesn't like that because ReadXML wants a string, I assume a filename?

score 35 · Accepted Answer · answered May 07 '09 at 20:51

35

No hacks required:

xmlAPDP = new XmlDocument()
...
xmlReader = new XmlNodeReader(xmlAPDP)
dataSet = new DataSet()
...
dataSet.ReadXml(xmlReader)

XmlDocument is an XmlNode, and XmlNodeReader is a XmlReader, which ReadXml accepts.

answered May 07 '09 at 20:51

Matthew Flaschen

278,309
50
514
539

8

Matthew : dont forget to close you XmlReader, or better use "using": `using (XmlReader reader = new XmlNodeReader(xmlAPDP.documentElement)) { dsAPDP.ReadXml(reader); reader.Close(); } dtAPDP = dsAPDP.tables[0];` – omadawn Nov 16 '09 at 21:57

score 3 · Answer 2 · answered Jan 11 '10 at 17:34

ASP.net example:

private DataTable GetReportDataTable()
{
    //get mapped path to xml document
    string xmlDocString = Server.MapPath("CustomReports.xml");

    //read into dataset
    DataSet dataSet = new DataSet();
    dataSet.ReadXml(xmlDocString);

    //return single table inside of dataset
    return dataSet.Tables[0];
}

score 2 · Answer 3 · answered May 07 '09 at 20:30

2

How about something like this?

dsAPDP.ReadXml(new MemoryStream(ASCIIEncoding.ASCII.GetBytes(xmlAPDP.OuterXml)))

answered May 07 '09 at 20:30

Kon

27,113
11
60
86

C# XMLDocument to DataTable?

3 Answers3