looping through XML file using VB.NET

Question

I am having a problem processing an XMl file. I want to loop through (using VB.NET) the file and extract all the values of the OrderID element.

<?xml version="1.0"?>
<ListOrdersResponse xmlns="https://xxx.xxxxxx.com/Orders/999uuu777">
  <ListOrdersResult>
    <NextToken>XXXXXXXXXX</NextToken>
    <Orders>
      <Order>
        <ShipmentServiceLevelCategory>Standard</ShipmentServiceLevelCategory>
        <OrderId>ooooooooo</OrderId>
      </Order>
      <Order>
        <ShipmentServiceLevelCategory>Standard</ShipmentServiceLevelCategory>
        <OrderId>ujuujujuj</OrderId>
      </Order>
      </Orders>
    <CreatedBefore>2013-06-19T09:10:47Z</CreatedBefore>
  </ListOrdersResult>
  <ResponseMetadata>
    <RequestId>8e34f7d9-3af7-4490-801b-cccc7777yu</RequestId>
  </ResponseMetadata>
</ListOrdersResponse>

Here is the code I am trying but it does not loop through each order

Dim doc As New XmlDocument()
doc.Load(file)
Dim nodelist As XmlNodeList = doc.SelectNodes(".//Orders/Order")
For Each node As XmlElement In nodelist
   console.writeline(node.SelectSingleNode("OrderID").InnerText)
Next

Any help would be gratefully appreciated.

Antonio · Accepted Answer · 2014-02-04 15:28:57Z

13

Try this:

doc.Load(file)
nodelist = doc.GetElementsByTagName("Order")

For Each node As XmlElement In nodelist
   Console.Writeline(node("OrderID").InnerText)
Next

edited Feb 4, 2014 at 15:28

answered Jun 24, 2013 at 14:38

Antonio

9,89215 gold badges63 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Antonio · Accepted Answer · 2013-06-24 14:39:35Z

2

The xPath expression I run that gets both orders is //tns:Order

Dim doc As New XmlDocument()
doc.Load(file)
Dim nodelist As XmlNodeList = doc.SelectNodes("//tns:Order")
For Each node As XmlElement In nodelist
  '2 exist
Next

edited Jun 24, 2013 at 14:39

Antonio

9,89215 gold badges63 silver badges91 bronze badges

answered Jun 24, 2013 at 13:35

OneFineDay

9,0344 gold badges28 silver badges37 bronze badges

5 Comments

user2516387 Over a year ago

Thanks for the response. If I replace ".//Orders/Order" with "//tns:Order" I get an exception. Can you explain what the //tns: path is?

user2516387 Over a year ago

Sorry forgot to attach the exception. It is Namespace Manager or XsltContext needed. This query has a prefix, variable, or user-defined function.

JDB Over a year ago

@user2516387 - tns is just the xml namespace alias that DonA used when creating a sample program. You can remove that.

user2516387 Over a year ago

if I use "//Order" it fails to process the for...next loop it ie. returns 0 nodes.

OneFineDay Over a year ago

That's the path LiquidXML came up with. I thought it was odd, since I remembered using //Order in the past.

Collectives™ on Stack Overflow

looping through XML file using VB.NET

2 Answers 2

Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related