Read complicated xml into a DataSet
Posted on 2006-11-20
I am trying to read in an XML doc ument into a DataSet such that I can get the data and potentially re-set values as well. The XML document looks as follows:
<remark>Password for database.</remark>
<remark>Path for location of file.</remark>
<pvalRemark>Relative path to foo 1.</pvalRemark>
<pvalRemark>Relative path to bar 1.</pvalRemark>
<ConfigTimeRemark>Relative path to time field.</ConfigTimeRemark>
As you can see there is a bit of nesting here so getting tables and rows is a bit different. The "Paths" section can have any number of 'pval' / 'pvalRemark' entries.
Simply using ds.Tables["SEC-A01"].Rows["pval"].toString() or any combination that I've tried throws exceptions.
How can I use DataSet/DataTable/DataRow (to which ever combination) to get the data from this xml doc?