iterate through all nodes of an xml file

Question

<ArrayOfContacts xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="someschema">
 <Contact>
    <ID />
    <First_Name />
    <Last_Name />
    <TelephoneNumbers>
        <TelephoneNumber>
            <Number />
            <IsHome />
            <IsWork />
            <IsCell />
            <ReachableAfterHrs />
        </TelephoneNumber>
    </TelephoneNumbers>
 </Contact>
  <Contact>
    <ID />
    <First_Name />
    <Last_Name />
    <TelephoneNumbers>
        <TelephoneNumber>
            <Number />
            <IsHome />
            <IsWork />
            <IsCell />
            <ReachableAfterHrs />
        </TelephoneNumber>
    </TelephoneNumbers>
 </Contact>
</ArrayOfContacts>

Looked at this article. Looking for a good way to go over the entire xml and change all node values that need to be changed, this would be dynamically chosen and then to save the document

My recursive routine is similar to this

however when it encounters <TelephoneNumbers> it does not go down deeper to get the individual elements.

My fn to recurse thru the XMl

Protected Sub RecurseXML(nodes As XmlNodeList)
    For Each node As XmlNode In nodes
        If (node.ChildNodes.Count > 1) Then
            RecurseXML(node.ChildNodes)
        Else
            node.InnerText = ChangeNodeValue()
        End If
    Next
End Sub

Basically, trying to read entire XML and change certain vlues[node names not known] and then save the update document.

Can you post your existing code? – Szymon Nov 18 '13 at 19:05 — Szymon, Nov 18 '13 at 19:05
I treid, SO tells me I have too much code. – user1361914 Nov 18 '13 at 19:17 — user1361914, Nov 18 '13 at 19:17

score 1 · Accepted Answer · answered Nov 18 '13 at 19:23

1

Your code doesn't go into <TelephoneNumbers> because of line

If (node.ChildNodes.Count > 1) Then

There's only one child element here so it stops at that level.

answered Nov 18 '13 at 19:23

Szymon

42,577
16
96
114

any recommendation to get around it? – user1361914 Nov 18 '13 at 19:30
1

Change `(node.ChildNodes.Count > 1)` to `(node.ChildNodes.Count > 0)`. – IAbstract Nov 18 '13 at 19:31
Doing that the recursion breaks out from the first node and does not go through the rest of the doc. – user1361914 Nov 18 '13 at 19:36
Why? The first node has children. – Szymon Nov 18 '13 at 19:43

iterate through all nodes of an xml file

1 Answers1