Extract Block of XML Nodes

See more:

VB

XML

Hi Guys,

I am attemtping to to databind a gridview to a DataSet which has data extracted from an xml string.

I retrieve the Xml string and am attempting to use the XPathNavigator to read the subtree to extract the nodes that i want to assign to the dataset.

I am however failing to do so. When i run the code, the subtree always brings back the entire Xml string instead of the desired 'block' of Nodes i am trying to extract.

<pre lang="vb">Dim xmlVal = "<xml content here>"
          Dim dsHistoryData As New DataSet()

          Dim xmlSR As System.IO.StringReader = New System.IO.StringReader(xmlVal)
          Dim document As System.Xml.XPath.XPathDocument = New System.Xml.XPath.XPathDocument(xmlSR)
          Dim navigator As System.Xml.XPath.XPathNavigator = document.CreateNavigator()

          Dim house As System.Xml.XmlReader = navigator.ReadSubtree()
          Dim myTest As String

          'Stream the book element and its child nodes to the XmlReader.
          navigator.MoveToChild(&quot;HouseHistory&quot;, &quot;&quot;)
          navigator.MoveToChild(&quot;House&quot;, &quot;&quot;)
  

          While book.Read
              myTest += house.ReadInnerXml() + "<br>"
          End While

          Response.Write(myTest)
          Response.End()

eg. of Xml string

<pre lang="xml">
<HouseInputData>
    <HouseAddedBy>Joe Soap</HouseAddedBy>
</HouseInputData>
<HouseOutputData>
    <HouseAddress>99318</HouseAddress>
    <History>
        <HouseHistory>
            <House>
                <OwnerTitleCode>Mr      </OwnerTitleCode>
                <OwnerInitials>MH</OwnerInitials>
                <OwnerSurname>ANA</OwnerSurname>
                <OwnerFirstName>HENDERSON</OwnerFirstName>
            </House>
        </HouseHistory>
    </History>
</HouseOutputData>

Any help would be greatly appreciated.