Read XML file into combo box....

[gmatteson]

<?xml version="1.0"?>
<chimaera>
<servers>
<host ip="172.16.1.30">Chimaera</host>
<host ip="172.16.1.31">MySQL1</host>
<host ip="172.16.1.32">Ares</host>
</servers>
</chimaera>

How can I read the above xml file into a combobox with the server names?

While myXML.Read
If XmlNodeType.Element Then
If myXML.Name = "hosts" Then
myXML.MoveToAttribute("ip")
MsgBox(myXML.ReadAttributeValue)
End If
End If
End While

this is what i have but it won't work. i'm trying to read the attribute "IP"

[Edneeis]

Dim ds As New DataSet
        ds.ReadXml("..\xmlfile1.xml")
        ComboBox1.DisplayMember = "host_Text"
        ComboBox1.DataSource = ds.Tables("host")

[Edneeis]

Or if you don't want to use databinding or like the XMLDocument object better then:

Dim dom As New Xml.XmlDocument
        dom.Load("..\xmlfile1.xml")
        ComboBox1.Items.Clear()
        For Each node As Xml.XmlNode In dom.SelectNodes("//chimaera/servers/host")
            ComboBox1.Items.Add(node.InnerText)
        Next

[gmatteson]

thank you. that sure cut down on a lot of code! do you have any links or tutorials more info regarding xml and vb.net? thanks. code works great btw.

[gmatteson]

Dim myAttr As XmlAttribute
For Each myAttr In myDoc.SelectNodes("/chimaera/servers/host")
MsgBox(myAttr.InnerText)
Next

can you use something like that to get the attributes? such as the ip?

[Edneeis]

Sorry I don't have any links off the top of my head, but a search for for xml and vb.net might work. Or you want to learn more about using the xmldocument and SelectNodes then check the help and google for xpath or xquery. You can do some cool queries in an xml file.

[Edneeis]

Sure, you can use the @ to note an attribute:

Dim myAttr As Xml.XmlAttribute
        For Each myAttr In myDoc.SelectNodes("/chimaera/servers/host/@ip")
            MsgBox(myAttr.InnerText)
        Next

[gmatteson]

Thank you.