Xml And Treeview

[carlblanchard]

hI ALL

ok ive got my database returning a record set in the form of xml
it basically uses the Microsoft data access block to return a dataset as xml......

i now what to filter all the records from the xml and stick them into my treeview (i can do the adding to treeview bit, however every charicter is a node)

so my question is "HOW DO I TURN MY XML INTO JUST VALUES WITHOUT ALL THE CRAP SHOWN BELOW"

current============================
<NewDataSet>
<Table>
<fullname>Carl Blanchard</fullname>
</Table>
<Table>
<fullname>Richard Dobson</fullname>
</Table>
<Table>
<fullname>Richard Dobson</fullname>
</Table>
</NewDataSet>

would like============================
Carl Blanchard
Richard Dobson
Richard Dobson

code examples are fully welcome

[axion_sa]

It's in C#, but easily converted to VB.Net:

// Where xmlResults is a XmlDocument.
XmlNodeList fullNameNodes = xmlResults.SelectNodes("NewDataSet/Table/fullname");
foreach (XmlNode fullNameNode in fullNameNodes)
{
    string fullName = fullNameNode.InnerText;
    System.Diagnostics.Debug.WriteLine(fullName);
}