• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

XML navigation in VB .NET

I am new to xml navigation in .NET so I have a fairly basic question I hope someone can help me with.

I have a xml file with a similar structure as shown below. I iterate through the node list and find the node I need based on field1. However I am not sure how I can reach the value I need which is field2.

Maybe it is a better approach to set the navigator to ""/message/value" and then retreive each child individually. If so any advise of the syntax will be very good.

Thanks J
<?xml version="1.0" encoding="iso-8859-1"?>
<message>
  <value>
    <field1>0001</field1>
    <field2>This is the text I need for 0001</field2>
  </value>
  <value>
    <field1>0002</field1>
    <field2>This is the text I need for 0002</field2>
  </value>
</message>
 
 
  Dim xpathDoc As XPathDocument
        Dim xmlNav As XPathNavigator
        Dim xmlNI As XPathNodeIterator
 
        Dim _strValue As String = ""
 
 
        xpathDoc = New XPathDocument("C:\test.xml")
        xmlNav = xpathDoc.CreateNavigator()
 
 
       xmlNI = xmlNav.Select("/message/value/field1")
 
            While (xmlNI.MoveNext())
 
                If xmlNI.Current.Value = "0001" Then
                    _strValue= some code here to retrieve value "This is the text I need 0001"
                    Exit While
                End If
 
            End While

Open in new window

0
jes12345
Asked:
jes12345
  • 3
1 Solution
 
mvgeertruyenCommented:
Not perfect but answers your question:
        xmlNI = xmlNav.Select("/message/value")
 
        While (xmlNI.MoveNext())
 
            If xmlNI.Current.SelectSingleNode("field1").Value = "0001" Then
                '_strValue= some code here to retrieve value "This is the text I need 0001"
                Debug.Write(xmlNI.Current.SelectSingleNode("field2"))
                Exit While
            End If
 
        End While

Open in new window

0
 
jes12345Author Commented:
Thanks for the advise - I have left the office for the day but will test it out first thing.
Thanks J
0
 
jes12345Author Commented:
Woked like a charm - many thanks for the advise! J
0
 
jes12345Author Commented:
I think it was perfect:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now