VB.NET: Simple XML problem....[Resolved]

Say i have these XML tag:

Code:

---

<Books country = "USA" date= "21/1/2005">
      <Title section ="1">
          <Reference web = "www.any.com" topic = "1">
      </Title>
      <Title section ="1">
          <Reference web = "www.idea.com" topic = "2">
      </Title>
      <Title section ="2">
          <Reference web = "www.howTo.com" topic = "3">
      </Title>
      <Title section ="3">
          <Reference web = "www.do.com" topic = "4">
      </Title>
</Books>

---

how do i actually extract the country and date attributes using XMLDocument...

I tried but it could not worked, below is my coding

Code:

---

Dim cou, da As Integer
Dim xdoc As New XmlDocument
Dim nodelist As XmlNodeList
Dim node As XmlNode

xdoc.Load("..\book.xml")

nodelist = xdoc.SelectNodes("/Books")

For Each node In nodelist
  cou = node.Attributes.GetNamedItem("country").Value
  MessageBox.Show(cou)
  da = node.Attributes.GetNamedItem("date").Value
  MessageBox.Show(da)
Next

---

Thanks

You use the @ symbol to get an attribute, for instance.

VB Code:

Dim cou, da As Integer
Dim xdoc As New XmlDocument
Dim nodelist As XmlNodeList
Dim node As XmlNode
 
xdoc.Load("..\book.xml")
 
nodelist = xdoc.SelectNodes("/Books")
 
For Each node In nodelist
  cou = node.SelectSingleNode("@country").InnerText
  MessageBox.Show(cou)
  da = node.SelectSingleNode("@date").InnerText
  MessageBox.Show(da)
Next

however I couldn't test it with your data, I kept getting some system exception which was quite strange.

Sorry Ideas man, actually both of our code could work....

The mistake was i forget to check the XML tag ...

All the Reference tag should end with an proper end tag..

Example:
<Reference web = "www.any.com" topic = "1" />

Thanks

Oh yeah, well spotted. I didn't see that, such a small issue caused such a large problem.