Solved

# Error reading certain lines of an XML

Posted on 2009-05-06
191 Views
I am having an issue reading a node from certain XML files. Below is the code I use to read most XML files that my app needs. However this code seems to have an issue reading a certain file. I believe it is because of:
<statuses type="array">

Is there a way to read this XML file?
Dim xml As Object
Dim XMLDoc As New XmlDocument
Dim nodeList As XmlNodeList
Dim node As XmlNode

nodeList = XMLDoc.SelectSingleNode("/status/user").ChildNodes
For i As Integer = 0 To nodeList.Count - 2 Step 2
node = nodeList(i)
Dim user As String = node.InnerText
MessageBox.show(user)
Next

<?xml version="1.0" encoding="UTF-8"?>
<status>
<user>Testing</user>
</status>

'However the code below will not read the XML below.

Dim xml As Object
Dim XMLDoc As New XmlDocument
Dim nodeList As XmlNodeList
Dim node As XmlNode

nodeList = XMLDoc.SelectSingleNode("statuses/status/text").ChildNodes
For i As Integer = 0 To nodeList.Count - 2 Step 2
node = nodeList(i)
Dim text As String = node.InnerText
MessageBox.show(text)
Next

<?xml version="1.0" encoding="UTF-8"?>
<statuses type="array">
<status>
<text>Another Test</test>
</status>
</statuses>

0
Question by:zerogeek
• 8
• 4

LVL 8

Expert Comment

ID: 24316748
Please include the xml data that is failing.
0

Author Comment

ID: 24316796
It is listed under the code I am using to read the XML:

<?xml version="1.0" encoding="UTF-8"?>
<statuses type="array">
<status>
<text>Another Test</test>
</status>
</statuses>

It doesn't fail. It runs thru the code but never shows the messagebox.
MessageBox.show(text)
0

LVL 8

Expert Comment

ID: 24316852

<text>Another Test</test>

text and test. typo :]
0

Author Comment

ID: 24316903
Actually, I wrote that up really quick. It is an example of  the XML I am using.
0

Author Comment

ID: 24316925
I believe it has something to do with the code that reads the XML file. It seems to be getting hung up on the <statuses type="array"> and either skipping the entire XML or not getting deep enough into the nodes to read the innerText of <text>Another Test</text>
0

LVL 8

Expert Comment

ID: 24317133
The problem was your for loop.

The SelectSingleNode found the xpath just fine.

See below for changes.
Dim xml As Object = Nothing
Dim XMLDoc As New XmlDocument()
Dim nodeList As XmlNodeList
Dim node As XmlNode

nodeList = XMLDoc.SelectSingleNode("statuses/status/text").ChildNodes
For i As Integer = 0 To nodeList.Count - 1
node = nodeList(i)
Dim text As String = node.InnerText
MessageBox.show(text)
Next

0

Author Comment

ID: 24317256
That seems to be working. Is there a way to make this grab up to 10 more from the file? Example of XML below
<?xml version="1.0" encoding="UTF-8"?>
<statuses type="array">
<status>
<text>Testing</text>
</status>
<status>
<text>Number 2</text>
</status>
<status>
<text>And so on...</text>
</status>

0

Author Comment

ID: 24317273
Their are multiple <status> tags in 1 XML file between the <statuses type="array"> and </statuses> tags
0

LVL 8

Accepted Solution

RyanAndres earned 250 total points
ID: 24317310

Dim XMLDoc As New XmlDocument()
Dim nodeList As XmlNodeList

nodeList = XMLDoc.SelectNodes("statuses/status/text")

For Each node As XmlNode In nodeList
Dim text As String = node.InnerText
Next

0

Author Comment

ID: 24317371
That did not work. It still only grabs the text from the first tag.
0

Author Comment

ID: 24317419
Nevermind. I didn't notice the change from XMLDoc.SelectSingleNode to SelectNodes

Thanks for all your help. :)
0

Author Closing Comment

ID: 31578522
Great help in a short amount of time. Much appreciated.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…