Getting node names from XML

[vbmark]

I have the follwing XML string:

<RecordSet>
<Row RowNumber="1">
<UserID>111</UserID>
<Phone>1234567890</Phone>
</Row>
<Row RowNumber="2">
<UserID>747</UserID>
<Phone>9876543210</Phone>
</Row>
</RecordSet>

A <Row> can have a variable number of elements in it.

How do I get a list of the elements? Such as in the
above case would be UserID and Phone?

My goal is to convert the XML into a Dataset.

Thanks!

[Steve Long]

Here's one way:

Public Function GetNodes(ByVal xpathExpression As String) As String()
Dim node As XmlNode = m_root.SelectSingleNode(xpathExpression)
If node Is Nothing Then Return Nothing
Dim nodelist As XmlNodeList = node.ChildNodes
Dim s(nodelist.Count - 1) As String
Dim i As Integer = 0
For Each xnode As XmlNode In nodelist
s(i) = xnode.Name
i += 1
Next
Return s
End Function

HTH
Steve

"vbmark" <[e-mail]> wrote in message
news:Xn************************@199.45.49.11...

I have the follwing XML string:

<RecordSet>
<Row RowNumber="1">
<UserID>111</UserID>
<Phone>1234567890</Phone>
</Row>
<Row RowNumber="2">
<UserID>747</UserID>
<Phone>9876543210</Phone>
</Row>
</RecordSet>

A <Row> can have a variable number of elements in it.

How do I get a list of the elements? Such as in the
above case would be UserID and Phone?

My goal is to convert the XML into a Dataset.

Thanks!

[Marcie Jones]

Hi Mark,
Any reason you can't just read the Xml directly into a DataSet, using
the .ReadXml() method?

Marcie

On Tue, 26 Apr 2005 19:36:59 GMT, vbmark <[e-mail]> wrote:

I have the follwing XML string:

<RecordSet>
<Row RowNumber="1">
<UserID>111</UserID>
<Phone>1234567890</Phone>
</Row>
<Row RowNumber="2">
<UserID>747</UserID>
<Phone>9876543210</Phone>
</Row>
</RecordSet>

A <Row> can have a variable number of elements in it.

How do I get a list of the elements? Such as in the
above case would be UserID and Phone?

My goal is to convert the XML into a Dataset.

Thanks!

[vbmark]

I could not get it to work for me. I'm sure that I just wasn't doing
something right.

Marcie Jones <ma*********@yahoo.com> wrote in
news:oi********************************@4ax.com:

Hi Mark,
Any reason you can't just read the Xml directly into a DataSet, using
the .ReadXml() method?

Marcie

On Tue, 26 Apr 2005 19:36:59 GMT, vbmark <[e-mail]> wrote:

I have the follwing XML string:

<RecordSet>
<Row RowNumber="1">
<UserID>111</UserID>
<Phone>1234567890</Phone>
</Row>
<Row RowNumber="2">
<UserID>747</UserID>
<Phone>9876543210</Phone>
</Row>
</RecordSet>

A <Row> can have a variable number of elements in it.

How do I get a list of the elements? Such as in the
above case would be UserID and Phone?

My goal is to convert the XML into a Dataset.

Thanks!

[vbmark]

What's m_root?

"Steve Long" <St**********@NoSpam.com> wrote in news:#dnCXtpSFHA.3244
@TK2MSFTNGP15.phx.gbl:

Here's one way:

Public Function GetNodes(ByVal xpathExpression As String) As String()
Dim node As XmlNode = m_root.SelectSingleNode(xpathExpression)
If node Is Nothing Then Return Nothing
Dim nodelist As XmlNodeList = node.ChildNodes
Dim s(nodelist.Count - 1) As String
Dim i As Integer = 0
For Each xnode As XmlNode In nodelist
s(i) = xnode.Name
i += 1
Next
Return s
End Function

HTH
Steve

"vbmark" <[e-mail]> wrote in message
news:Xn************************@199.45.49.11...

I have the follwing XML string:

<RecordSet>
<Row RowNumber="1">
<UserID>111</UserID>
<Phone>1234567890</Phone>
</Row>
<Row RowNumber="2">
<UserID>747</UserID>
<Phone>9876543210</Phone>
</Row>
</RecordSet>

A <Row> can have a variable number of elements in it.

How do I get a list of the elements? Such as in the
above case would be UserID and Phone?

My goal is to convert the XML into a Dataset.

Thanks!

[Marcie Jones]

Did it give you an error, or was the data not stored in the way you
wanted it?

Marcie

On Tue, 26 Apr 2005 20:25:12 GMT, vbmark <[e-mail]> wrote:

I could not get it to work for me. I'm sure that I just wasn't doing
something right.

Marcie Jones <ma*********@yahoo.com> wrote in
news:oi********************************@4ax.com :

Hi Mark,
Any reason you can't just read the Xml directly into a DataSet, using
the .ReadXml() method?

Marcie

On Tue, 26 Apr 2005 19:36:59 GMT, vbmark <[e-mail]> wrote:

I have the follwing XML string:

<RecordSet>
<Row RowNumber="1">
<UserID>111</UserID>
<Phone>1234567890</Phone>
</Row>
<Row RowNumber="2">
<UserID>747</UserID>
<Phone>9876543210</Phone>
</Row>
</RecordSet>

A <Row> can have a variable number of elements in it.

How do I get a list of the elements? Such as in the
above case would be UserID and Phone?

My goal is to convert the XML into a Dataset.

Thanks!

[Steve Long]

Opps! Sorry. You select that first thing. It's the DocumentElement of the
XmlDocument
Dim m_xmldoc as New XmlDocument
Dim m_root as XmlElement
m_xmldoc.Load(fileNameandPath)
m_root = m_xmldoc.DocumentElement
"vbmark" <[e-mail]> wrote in message
news:Xn************************@199.45.49.11...

What's m_root?

"Steve Long" <St**********@NoSpam.com> wrote in news:#dnCXtpSFHA.3244
@TK2MSFTNGP15.phx.gbl:

Here's one way:

Public Function GetNodes(ByVal xpathExpression As String) As String()
Dim node As XmlNode = m_root.SelectSingleNode(xpathExpression)
If node Is Nothing Then Return Nothing
Dim nodelist As XmlNodeList = node.ChildNodes
Dim s(nodelist.Count - 1) As String
Dim i As Integer = 0
For Each xnode As XmlNode In nodelist
s(i) = xnode.Name
i += 1
Next
Return s
End Function

HTH
Steve

"vbmark" <[e-mail]> wrote in message
news:Xn************************@199.45.49.11...

I have the follwing XML string:

<RecordSet>
<Row RowNumber="1">
<UserID>111</UserID>
<Phone>1234567890</Phone>
</Row>
<Row RowNumber="2">
<UserID>747</UserID>
<Phone>9876543210</Phone>
</Row>
</RecordSet>

A <Row> can have a variable number of elements in it.

How do I get a list of the elements? Such as in the
above case would be UserID and Phone?

My goal is to convert the XML into a Dataset.

Thanks!