Tired and dumb. XML & the DOM

[nickjaffe]

Hi all,

I've spent literally hours trying to figure this one out. I'm
re-developing an app from vb6 to vb.net, and I cannot get my XML code
working. I've just started using .NET. I'm tired, highly annoyed and
this is my problem (I know it is very easy for someone who has done
this before):

My entire XML file is here - The '<CALL_12260>' tag name is dynamic
(the XML file is generated by something else), everything else stays
the same. I would like to easily read the contents of every node
selectively:

<CDC>
<CALL_12260>
<JobKey>65</JobKey>
<hTapiCall>1226 0</hTapiCall>
<JobMode>1</JobMode>
<JobState>1</JobState>
<ForeignTel>004 4863313</ForeignTel>
<OwnerTel></OwnerTel>
<RedirectingID> </RedirectingID>
<RedirectionID> </RedirectionID>
<Profile>Enterp riseApplication </Profile>
<ADRKey>13</ADRKey>
<ADRText>BLEH </ADRText>
<CustomerID>1 3</CustomerID>
<ASPKey></ASPKey>
<ASPText></ASPText>
<ASPFound>0</ASPFound>
<ADRFound>-1</ADRFound>
<Date>21/08/2006</Date>
<Time>14:59:2 6</Time>
<Choices></Choices>
<Contacts></Contacts>
</CALL_12260>
</CDC>

My lame attempts at .NET - I have no idea what I'm doing with
traversing the DOM...

xmlOBJ.Load(xml PathTXT)
xmlNodeList = xmlOBJ.SelectNo des("//CDC/*")

For Each xmlNode In xmlNodeList
xmlNode.FirstCh ild.NodeType
Console.WriteLi ne(xmlNode.Chil dNodes.Count)
Next

I've just been noodling around with X number of configurations of the
above trying to get something useful. Nada.

Thanks for reading my pleas for help, apologies in advance for posting
such a stupid request.

n

[nickjaffe]

Seem to have solved it myself. Not sure if this is the best way, but I
like it. Amazing what going to sleep can do.

FYI for future developers:

Imports System.IO
Imports System.Xml

Public Function XMLPoo()

Dim xmlPathTXT As String
Dim xmlNode As XmlNode
Dim xmlNodeList As XmlNodeList
Dim xmlRoot As XmlNode
Dim xmlNodesCollect ion As New Collection

xmlPathTXT = "myXML.xml"
xmlOBJ.Load(xml PathTXT)
xmlRoot = xmlOBJ.Document Element
xmlNodeList = xmlRoot.SelectN odes("/CDC/*/*")

For Each xmlNode In xmlNodeList
xmlNodesCollect ion.Add(xmlNode .InnerText.ToSt ring,
xmlNode.Name.To String)
Next

Return xmlNodesCollect ion

End Function


ni*******@gmail .com wrote:

Hi all,

I've spent literally hours trying to figure this one out. I'm
re-developing an app from vb6 to vb.net, and I cannot get my XML code
working. I've just started using .NET. I'm tired, highly annoyed and
this is my problem (I know it is very easy for someone who has done
this before):

My entire XML file is here - The '<CALL_12260>' tag name is dynamic
(the XML file is generated by something else), everything else stays
the same. I would like to easily read the contents of every node
selectively:

<CDC>
<CALL_12260>
<JobKey>65</JobKey>
<hTapiCall>1226 0</hTapiCall>
<JobMode>1</JobMode>
<JobState>1</JobState>
<ForeignTel>004 4863313</ForeignTel>
<OwnerTel></OwnerTel>
<RedirectingID> </RedirectingID>
<RedirectionID> </RedirectionID>
<Profile>Enterp riseApplication </Profile>
<ADRKey>13</ADRKey>
<ADRText>BLEH </ADRText>
<CustomerID>1 3</CustomerID>
<ASPKey></ASPKey>
<ASPText></ASPText>
<ASPFound>0</ASPFound>
<ADRFound>-1</ADRFound>
<Date>21/08/2006</Date>
<Time>14:59:2 6</Time>
<Choices></Choices>
<Contacts></Contacts>
</CALL_12260>
</CDC>

My lame attempts at .NET - I have no idea what I'm doing with
traversing the DOM...

xmlOBJ.Load(xml PathTXT)
xmlNodeList = xmlOBJ.SelectNo des("//CDC/*")

For Each xmlNode In xmlNodeList
xmlNode.FirstCh ild.NodeType
Console.WriteLi ne(xmlNode.Chil dNodes.Count)
Next

I've just been noodling around with X number of configurations of the
above trying to get something useful. Nada.

Thanks for reading my pleas for help, apologies in advance for posting
such a stupid request.

n