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

[toytoy]

Say i have these XML tag:

<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

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

[Ideas Man]

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

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.

[toytoy]

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

[Ideas Man]

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