Reading An XML File

Hi GUys,

i have my .xml files written like:

vb.net Code:

<?xml version="1.0" encoding="utf-8"?>
<hiddenFields>
   <hiddenFieldsIDNumber0>sta</hiddenFieldsIDNumber0>
   <hiddenFieldsIDNumber1>mand</hiddenFieldsIDNumber1>
</hiddenFields>

I'm trying to read the values but i'm not having much luck, i have this:

vb.net Code:

Function functionLoadHiddenFields(ByVal fileLocation As String)
 
        Try
 
            '// Check if the file exists
            If File.Exists(fileLocation) Then
 
                '// Load the xml document
                Dim XMLDoc As New Xml.XmlDocument
 
                '// Find and load the XML file
                XMLDoc.Load(fileLocation)
 
                '// Tell where to look for the data we need
                Dim XMLItem As Xml.XmlNode = XMLDoc.SelectSingleNode("hiddenFields/")
 
            Else
                '// oops, the file is missing or wasn't written!
                MessageBox.Show("A file is missing that we need to use!, please restart the program", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
            End If
 
        Catch ex As Exception
 
            Return False
 
        End Try
 
    End Function

i'm not to sure how to get the individual values, any help would be great!

thanks guys

Graham

To read an xml file, you want to use the XmlReader class instead of the XmlDocument class.

You can find a entry in the VB.NET codebank about reader/writing xml.

look at the .hasChildren property as well as the .firstChild one...

-tg

Here are a couple XPATH samples

Code:

---

'get hiddenFields node
Dim xmlItem = XMLDoc.SelectSingleNode("hiddenFields")

'get hiddenFields child nodes
For Each xmlItem In XMLDoc.SelectNodes("hiddenFields/*")

Next

---