read xml and assign attributes to variables in vb.net

Question

I have a xml file

<config>
   <email Host="201.175.0.0" From="[email protected]" Pass="xxx" Name="NameT"/>
   <combo/>
   <list sex="female"/>
</config>

How can I assign the value of the attributes to variables in vb.net?

I was doing

Dim doc As XmlDocument = New XmlDocument()
doc.Load("Test.xml")
Dim Host = doc.DocumentElement.Attributes.ItemOf("Host").InnerText
Dim From = doc.DocumentElement.Attributes.ItemOf("From").InnerText
Dim Pass = doc.DocumentElement.Attributes.ItemOf("Pass").InnerText
Dim Name = doc.DocumentElement.Attributes.ItemOf("Name").InnerText

Is this correct, what would be a better approach?

David · Accepted Answer · 2012-12-05 23:09:33Z

1

Try this, instead:

Dim doc As XmlDocument = New XmlDocument()
doc.Load("Test.xml")
Dim root As XmlNode = doc.DocumentElement
Dim nodeEmail As XmlNode = root.SelectSingleNode("/config/email")
Dim Host As String = nodeEmail.Attributes.ItemOf("Host").InnerText
Dim From As String = nodeEmail.Attributes.ItemOf("From").InnerText
Dim Pass As String = nodeEmail.Attributes.ItemOf("Pass").InnerText
Dim Name As String = nodeEmail.Attributes.ItemOf("Name").InnerText

You might also want to consider using an associative array (Dictionary in VB) to store those attributes, rather than using a bunch of variables.

In that case, it would look like this:

Dim doc As XmlDocument = New XmlDocument()
doc.Load("Test.xml")
Dim root As XmlNode = doc.DocumentElement
Dim nodeEmail As XmlNode = root.SelectSingleNode("/config/email")
Dim dictionary As New Dictionary(Of String, String)
dictionary.Add("Host", nodeEmail.Attributes.ItemOf("Host").InnerText)
dictionary.Add("From", nodeEmail.Attributes.ItemOf("From").InnerText)
dictionary.Add("Pass", nodeEmail.Attributes.ItemOf("Pass").InnerText)
dictionary.Add("name", nodeEmail.Attributes.ItemOf("Name").InnerText)

edited Dec 5, 2012 at 23:09

answered Dec 5, 2012 at 22:57

David

6,5912 gold badges27 silver badges22 bronze badges

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

1 Comment

edgarmtze Over a year ago

thats a very good idea, do you have an example to use Dictionary?

Collectives™ on Stack Overflow

read xml and assign attributes to variables in vb.net

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related