loading XML into dataset

[lfc77]

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\

http://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,

lfc77

 

[QuantumDoja]

Try something like this...

<SCRIPT ID="clientEventHandlersVBS" LANGUAGE="vbscript">

     Sub MySub()
         Set objXML = CreateObject("Msxml2.FreeThreadedDOMDocument")
         objXML.async = False
			objXML.load("myxmlfile.xml")
         dsoMyDataIsland.loadxml objXML.xml
     End Sub

</SCRIPT>

http://www.demonasp.co.uk