How to read XML files?

[neodatatype]

Hi all,

Can someone tell me how can I have direct access to XML element/attribute?

sample:


<project name="myproject" attribute "myattribute">
<myelement name="elementname" />
<nestedelement x="1" y="2">
<row>first row</row>
</nestedelement >
</project>



Task 1: I want to know the attribute "name" of element "project"

Task 2: I want to know the attribute "name" of element "myelement"

Task 3: I want to know the element string of element "row"

All I got from sites and tutorials is how to parse the XML file and list alla elements/attributes, but I don't need a parsing, I need to go directly to an element and get its attributes.

How?

Thank you!

[Edneeis]

You can load it into a DataSet with the DataSet's ReadXML method or Load it into an XMLDocument and use the SelectSingleNode method to get what you need.

'load into a DataSet
Dim ds As New DataSet()
ds.ReadXml("..\xmlfile1.xml")
MsgBox(ds.Tables(0).Rows(0)("name"))
 
'load it into a XMLDocument
Dim xdoc As New Xml.XmlDocument()
xdoc.Load("..\xmlfile1.xml")
Dim xNode As Xml.XmlNode = xdoc.DocumentElement.SelectSingleNode("/project")
MsgBox(xNode.Attributes("name").Value)

*Also you need an = sign in here [attribute "myattribute"]