loading XML into a dataset

[Mike P]

I'm currently reading data from an XML file using XPathNavigator and
XPathNodeIterator to select the subset of data that I want. I've never
using the XPath objects before so I'm not sure how to get this data into
a dataset.

XPathDocument doc = new
XPathDocument(@"C:\inetpub\wwwroot\test\test.xml") ;
XPathNavigator nav = doc.CreateNavigator();
XPathNodeIterator iter =
nav.Select("/test/translation/engword[preceding-sibling::fraword = '" +
strFraWord + "']");

Can anybody help me out with this? Any assistance would be really
appreciated.
Cheers,

Mike

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Martin Honnen]

Mike P wrote:

I'm currently reading data from an XML file using XPathNavigator and
XPathNodeIterator to select the subset of data that I want. I've never
using the XPath objects before so I'm not sure how to get this data into
a dataset.

XPathDocument doc = new
XPathDocument(@"C:\inetpub\wwwroot\test\test.xml") ;
XPathNavigator nav = doc.CreateNavigator();
XPathNodeIterator iter =
nav.Select("/test/translation/engword[preceding-sibling::fraword = '" +
strFraWord + "']");

Can anybody help me out with this? Any assistance would be really
appreciated.

If you want to have the data in a dataset I think you should better use
XmlDataDocument as that has a synchronized DataSet property that you can
then use.

--

Martin Honnen
http://JavaScript.FAQTs.com/

[Mike P]

I'm finding loads of examples on the net like this, which show you how
to get the data that you want from the XML file, but have no mention of
datasets. Do you have a good example of how to do this?

XmlDataDocument mydocument = new XmlDataDocument();;
//Load your Xml document
mydocument.Load(Server.MapPath("EmpList.xml"));

//Use "SelectNodes" to get the Employee node where the attribute
"id=3"
//and write out the response.
XmlNodeList xmln =
this.mydocument.SelectNodes("//Employee[@id='3']");
Cheers,

Mike

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!