Please, Please help, this is really driving me crazy
I am trying to read the contents of an XML file, filter the results with XMLNodeReader & XPath and then save them to a DataSet ready for binding in my page.
The problem is that I can only seem to return one result using SelectSingleNode, as SelectNodes creates an XMLNodeList which XMLNodeReader doesn't like.
I get 'XMLNodeList cannot be converted to XMLNode'
Can anyone help, even if its a work around to get my filtered data into a DataSet. Thanks in Advance.
Here's the code.
Dim docReader As New XmlDocument
docReader.Load(Server.MapPath("myFile.xml"))
Dim nodeList As XmlNodeReader = New XmlNodeReader_
(docReader.DocumentElement.SelectNodes("channel/item"))
Dim docDataSet As New DataSet
docDataSet.ReadXml(nodeList)
RSSXMLDataList.DataSource = docDataSet.Tables(0).DefaultView
RSSXMLDataList.DataBind()