Xml [Resolved]

[tylerm]

I'm still struggling with XML. I have this XML file with hundreds of blocks that look like this:

<entry>
<name></name>
<website></website>
<username></username>
<password></password>
</entry>

How do I ready every "entry" and get the "name" and "website" into a listbox like: name ( website )

[kleinma]

is there a top level node of the XML? <entry> can't be the root in a well formed XML doc, as they are only supposed to have one root element... so is it something like

<entries>
  <entry>
    <name></name>
    <website></website>
    <username></username>
    <password></password>
  </entry>
  <entry>
    <name></name>
    <website></website>
    <username></username>
    <password></password>
  </entry>
</entries>

[tylerm]

yes, there is a top level called <mcbr>, but yes.

[kleinma]

ok.. will post some example code.. give me a minute

[kleinma]

ok here is some sample code..

if you don't understand it fully, and want to see it in action, you will need to stick this code in a form, and add a listbox (listbox1)

You would also need to put the xml document in the bin directory (where your exe is) and change my code's "testdata.xml" to whatever your XML file is actually called.

Dim XDoc As New Xml.XmlDocument
        Try
            'LOAD FILE INTO OBJECT
            XDoc.Load(Application.StartupPath & "\testdata.xml")
            'LOOP ALL THE CHILD NODES OF THE DOCUMENT'S DOCUMENTELEMENT PROPERTY
            For Each XNode As Xml.XmlNode In XDoc.DocumentElement.ChildNodes
                ListBox1.Items.Add(XNode.Item("name").InnerText)
                ListBox1.Items.Add(ControlChars.Tab & XNode.Item("website").InnerText)
                ListBox1.Items.Add(ControlChars.Tab & XNode.Item("username").InnerText)
                ListBox1.Items.Add(ControlChars.Tab & XNode.Item("password").InnerText)
            Next
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try

[kiwis]

Hmm I post this

Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click
 
 
        ListBox1.Items.Clear()
 
 
 
 
        Dim XDoc As New Xml.XmlDocument
        Try
            'LOAD FILE INTO OBJECT
            XDoc.Load("C:\Documents and Settings\Owner\Desktop\newslist.xml")
            'LOOP ALL THE CHILD NODES OF THE DOCUMENT'S DOCUMENTELEMENT PROPERTY
            For Each XNode As Xml.XmlNode In XDoc.DocumentElement.ChildNodes
                ListBox1.Items.Add(XNode.Item("rssid").InnerText)
                'ListBox1.Items.Add(ControlChars.Tab & XNode.Item("title").InnerText)
                'ListBox1.Items.Add(ControlChars.Tab & XNode.Item("link").InnerText)
            Next
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
End Sub

But I get the messagebox saying "Object reference not set to an instance of an object"

How can i fix this???

[kleinma]

what does newslist.xml look like?