Groups | Blog | Home
all groups > dotnet ado.net > march 2005 >

dotnet ado.net : using ReadXML with disparate XML data


Joe
3/30/2005 11:13:03 AM
I want to load data from two related but different XML files into a two
different DataTables in a single DataSet, then create relations, and finally
filter and select specific data. I can't figure out how to load the two
different sets of data into one DataSet. For example, the following results
in just one table, and no detail data:

XmlDataDocument datadoc = new XmlDataDocument();
datadoc.DataSet.ReadXml(new StreamReader(@"C:\temp\header.xml"),
XmlReadMode.Auto);
datadoc.DataSet.ReadXml(new StreamReader(@"C:\temp\detail.xml"),
XmlReadMode.Auto);

Trying a few variations of this code didn't get me any further.

anonymous NO[at]SPAM discussions.microsoft.com
3/30/2005 1:51:40 PM
DataSet ds = new DataSet();
ds.ReadXml(new StreamReader(@"C:\temp\header.xml"),
XmlReadMode.Auto);
ds.ReadXml(new StreamReader(@"C:\temp\detail.xml"),
XmlReadMode.InferSchema);

ds contains 2 DataTables. one is for header.xml, another
is for detail.xml

[quoted text, click to view]
Joe
3/31/2005 6:29:03 AM
Beautiful! The two different uses of the XmlReadMode param did the trick.
Thanks.

[quoted text, click to view]
AddThis Social Bookmark Button