VB.NET: Get the Attribute and Text out from Xml....[Resolved]

[toytoy]

ok....i fully understand what you mean..

now my concept on XPath is much more clearer...
I have finally resolve all my doubts..

Thanks Edneeis..

[toytoy]

Say i have these Xml tag

<Books>
      <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>

I want to extract all the web and topic attribute only in Title section "1"...

Thanks

[Edneeis]

Did you check out the example code I posted in the zip file?

It shows you how to do that. The only difference would be referring to the topic attribute exactly the way the example does the web attribute.

[toytoy]

yeah....cannot..

Once i selected ID "1" which is the same with two title data..

it display only the first data of web and topics since two have the same ID..

Say how to extract all web and topic involve same and different ID into the combo box ..

Thanks..

[Edneeis]

Then instead of calling SelectSingleNode use SelectNodes and loop through the results.

[toytoy]

From the previous Xml tags:

<Books>
      <Title section ="1">
          <Reference web = "www.any.com" topic = "1">
      </Title>
      <Title section ="5">
          <Reference web = "www.idea.com" topic = "2">
      </Title>
      <Title section ="5">
          <Reference web = "www.howTo.com" topic = "3">
      </Title>
      <Title section ="9">
          <Reference web = "www.do.com" topic = "4">
      </Title>
</Books>

Say i have 3 section name for the Title:
"1" stand for Science, "2" stand for Gerenal and "3" stand for History

when i receive the section attribute from the server, i have to do some comparing with the number...like 2 to the power of 1 indicate the event of Science, 2 to the power of 2 indicate Gerenal and so on.

Thus when i receive the number "5" for section in this case, it indicate the events of Science and Gerenal...
so all those fields with attribute "5" will be extract.......

The exponent method is:

 Public Function pow(ByVal exponent As Integer, ByVal base As Integer)

        result = base ^ exponent
        subtotal = result
        total = total + subtotal
        Return total

    End Function

with the above method, what should i do to compare the number with the section attributes correctly and display it to a listbox...

Currently, i may extract the web and topic.... but it will duplicate the values whenever i extract from it...

Example: listbox should contain:

www.howTo.com
3
www.idea.com
2

But my coding gave me this:

www.howTo.com
3
www.idea.com
2
www.howTo.com
3
www.idea.com
2
www.howTo.com
3
www.idea.com
2
www.howTo.com
3
www.idea.com
2

See, when i extract two sets of data, it will duplicate four sets instead...

Thanks

[toytoy]

According to the above XML tags...

I want to extract all attributes and display accordingly...

I will always have duplicate values...

That means...my looping is wrong..

Any ideas how to do a simple and accurate compare loop and extract the required attributes from all the loop into different listbox...

Thanks