using ReadXML with disparate XML data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top