How do I get the value from a specific node in an XML file?

Question

From this XML code: ``` Cruciatum 1000 10 100 Ghostbullet93 10 1 10 ``` How can I get (for example) the 10 next to `` ? I've tried multiple things without any success. One of the ideas I had was using this code: ``` Dim doc = XDocument.Load("C:\members.xml") Dim members = From m In doc.Element("Tabel").Elements("Member") Select naam = m.Element("Naam").Value For Each member In members lstmembers.Items.Add(member) Next ``` But I can't figure out how to edit that snippet to work with what I need it to do now. (The above code works perfectly for where it's used.)

Accepted Answer

You can also use XPath to read the element's value:

```
Dim doc As XmlDocument = New XmlDocument()
doc.Load("C:\members.xml")
Dim kills As String = doc.SelectNode("Tabel/Member[Naam='Ghostbullet93']/Kills").InnerText
```

If, however, you intend to load and use all the data, it would be far easier to use serialization. To do that, you first need to create classes that mimic the XML structure (for simplicity sake I'll just use public string fields, but it would be better to use properties):

```
Public Class Member
    Public Naam As String
    Public Kills As Integer
    Public Deaths As Integer
    Public KD As Integer
End Class

Public Class Tabel
    <XmlElement("Member")> _
    Public Members As List(Of Member)
End Class
```

Then deserialize the XML like this:

```
Dim serializer As XmlSerializer = New XmlSerializer(GetType(Tabel))
Dim tabel As Tabel = CType(serializer.Deserialize(File.OpenRead("C:\members.xml")), Tabel)
For Each member As Member in tabel
    Dim kills As Integer = member.Kills
Next
```

How do I get the value from a specific node in an XML file?

Solution

Problem