Steve Gray

Given the XML structure:

 <employees>
 <employee>
  <firstname>John</firstname>
  <lastname>Doe</lastname>
 </employee>
 <employee>
  <firstname>James</firstname>
  <lastname>Buck</lastname>
 </employee>
 <employees>


 

I sometimes need to loop (iterate) through the file and gather the first/last names

Here is a piece of code that will do that

            Dim xdoc As New XmlDocument
            xdoc.Load(URL)


            'get a nodeList filled with employee nodes
            Dim hNodes As XmlNodeList = xdoc.SelectNodes("employees/employee")
            For Each hNode As XmlNode In hNodes
                'get first and last names, store them
                strFirstName= hNode.SelectSingleNode("firstname").InnerText
                strLastName= hNode.SelectSingleNode("lastname").InnerText


            Next