In VB.net how do I concatenate the varied value of 3 tags all with the same name?

[NKeuxmuis]

How do I concatenate all of the interests from the following XML file into one variable using vb.net 4.

<xml>
     <client>
          <name>Paul Davis</name>
          <interest>Football</interest>
          <interest>Swimming</interest>
          <interest>Internet</interest>
     </client>
</xml>

The VB code I have so far is as follows

Dim buffer As String

For Each itm In clients
If (itm.<name>.Value = CType(Session("Client"), String)) Then
Continue For
End If

buffer &= "<table><tr>"
buffer &= String.Format("<td>{0}</td>", itm.<name>.Value)
buffer &= String.Format("<td>{0}</td>", // The interests should be selected here
buffer &= "</tr></table>"

Next
lblOutput.Text = buffer

[scdv2]

use XPath with an xmlDocument or XDocument if your want to use linq

To write the Html, i would use an xmlDocument for cleaner code.

[oracleguy]

Please do not cross post. Original thread: http://www.codingforums.com/showthread.php?t=225047