parsing a string as XML using VB.NET

[wk6pack]

Hi,

I would like to know how to parse the following xml string using vb.net?
currxml="
<employee><addr ess_2></address_2><assi gnments><assign ment><assigned_ bargaini
ng_unit></assigned_bargai ning_unit><assi gned_department ></assigned_depart men
t><assigned_loc ations><assigne d_location></assigned_locati on></assigned_loca
tions><assigned _position></assigned_positi on><assigned_po sition_departme nt><
/assigned_positi on_department></assignment></assignments><ca tegory>TEAC</cat
egory><city>VIC TORIA</city><country_c ode>CAN</country_code><d emographic_barg
aining_unit></demographic_bar gaining_unit><d emographic_depa rtment></demograp
hic_department> <demographic_lo cation></demographic_loc ation><demograp hic_pos
ition></demographic_pos ition><email></email><employee _no>202307</employee_no

<fax_no></fax_no><first_n ame>MURIEL</first_name><las t_name>ANDREWS</last_na

me><middle_name ></middle_name><mo st_assigned_bar gaining_unit></most_assigned
_bargaining_uni t><most_assigne d_department></most_assigned_d epartment><most _
assigned_locati on></most_assigned_l ocation><most_a ssigned_positio n></most_as
signed_position ><most_assigned _position_depar tment></most_assigned_p osition_
department><pos tal_code>V8S
5G5</postal_code><pr eferred_name></preferred_name> <province_code> BC</provinc
e_code><salutat ion>MS</salutation><sin >706257185</sin><status>T</status><str
eet>1050 DEAL STREET</street><telepho ne_no></telephone_no></employee>"

here is my code so far:
Dim strreader = New StringReader(cu rrxml)

Dim xmldoc As New XmlDocument

xmldoc.LoadXml( currxml)

reader = New XmlNodeReader(x mldoc)

While reader.Read

Select Case reader.NodeType

Case XmlNodeType.Ele ment

If reader.Name = "category" Then

MsgBox(reader.N ame)

End If

End Select

End While

I do see the read.Name as category but it doesnt give me "TEAC". I dont get
any value in the msgbox. It is blank. Am I missing something?

I see the value for city which is "VICTORIA" but the reader.Name is "".

thanks for you help,

Will

[Cor Ligthert]

WK6pack,

When you are lucky than it has a dataset format. Add for that a dataset from
the items to your solution and paste your file in, than you see that direct.

When not you can better take the XMLNodeReader
http://msdn.microsoft.com/library/de...classtopic.asp

I take the xmldoc only in JavaScript.

I hope this helps,

Cor

[wk6pack]

Hi Cor,

I'm not sure what you mean by dataset format. But I am using the
XMLNodeReader.
I would like to know how do I know the tag has a value or not.

thanks,
Will
"Cor Ligthert" <no************ @planet.nl> wrote in message
news:OT******** ******@TK2MSFTN GP14.phx.gbl...

WK6pack,

When you are lucky than it has a dataset format. Add for that a dataset from the items to your solution and paste your file in, than you see that direct.
When not you can better take the XMLNodeReader
http://msdn.microsoft.com/library/de...classtopic.asp
I take the xmldoc only in JavaScript.

I hope this helps,

Cor

[Jay B. Harlow [MVP - Outlook]]

wk6pack,
| I would like to know how to parse the following xml string using vb.net?
I would "parse" it with either a XmlTextReader, XmlDocument, or
XPathDocument, something like:

Dim currxml As String = ...

Dim input As New StringReader(cu rrxml)

Dim reader As New XmlTextReader(i nput)

If I loaded the string into an XmlDocument or an XPathDocument, I would use
the various methods on those objects (such as Select) to extract the content
that I need. Rarely would I "hand it back" to an XmlNodeReader.. .

| I do see the read.Name as category but it doesnt give me "TEAC". I dont
get
| any value in the msgbox. It is blank. Am I missing something?

Yes, you are confusing an Element Node with a Text Node. "<category> " is an
Element node, while "TEAC" is a Text Node which happens to be the contents
of the "<category> " Element node

| I see the value for city which is "VICTORIA" but the reader.Name is "".
Again, "VICTORIA" is a Text Node, which happens to be the contents of a
"<category> " Element node.

To see the different between the various node types, try:

Dim currxml As String = ...
Dim input As New StringReader(cu rrxml)
Dim reader As New XmlTextReader(i nput)

While reader.Read
Debug.WriteLine (reader.NodeTyp e, "node type")
Debug.WriteLine (reader.Prefix, "prefix")
Debug.WriteLine (reader.LocalNa me, "local name")
Debug.WriteLine (reader.Name, "name")
Debug.WriteLine (reader.Namespa ceURI, "namespace" )
Debug.WriteLine (reader.Value, "value")
Debug.WriteLine (Nothing)
End While

Hope this helps
Jay
"wk6pack" <wk***@sd61.bc. ca> wrote in message
news:O5******** ******@tk2msftn gp13.phx.gbl...
| Hi,
|
| I would like to know how to parse the following xml string using vb.net?
| currxml="
|
<employee><addr ess_2></address_2><assi gnments><assign ment><assigned_ bargaini
|
ng_unit></assigned_bargai ning_unit><assi gned_department ></assigned_depart men
|
t><assigned_loc ations><assigne d_location></assigned_locati on></assigned_loca
|
tions><assigned _position></assigned_positi on><assigned_po sition_departme nt><
|
/assigned_positi on_department></assignment></assignments><ca tegory>TEAC</cat
|
egory><city>VIC TORIA</city><country_c ode>CAN</country_code><d emographic_barg
|
aining_unit></demographic_bar gaining_unit><d emographic_depa rtment></demograp
|
hic_department> <demographic_lo cation></demographic_loc ation><demograp hic_pos
|
ition></demographic_pos ition><email></email><employee _no>202307</employee_no
|

<fax_no></fax_no><first_n ame>MURIEL</first_name><las t_name>ANDREWS</last_na

|
me><middle_name ></middle_name><mo st_assigned_bar gaining_unit></most_assigned
|
_bargaining_uni t><most_assigne d_department></most_assigned_d epartment><most _
|
assigned_locati on></most_assigned_l ocation><most_a ssigned_positio n></most_as
|
signed_position ><most_assigned _position_depar tment></most_assigned_p osition_
| department><pos tal_code>V8S
|
5G5</postal_code><pr eferred_name></preferred_name> <province_code> BC</provinc
|
e_code><salutat ion>MS</salutation><sin >706257185</sin><status>T</status><str
| eet>1050 DEAL STREET</street><telepho ne_no></telephone_no></employee>"
|
| here is my code so far:
| Dim strreader = New StringReader(cu rrxml)
|
| Dim xmldoc As New XmlDocument
|
| xmldoc.LoadXml( currxml)
|
| reader = New XmlNodeReader(x mldoc)
|
| While reader.Read
|
| Select Case reader.NodeType
|
| Case XmlNodeType.Ele ment
|
| If reader.Name = "category" Then
|
| MsgBox(reader.N ame)
|
| End If
|
| End Select
|
| End While
|
|
|
| I do see the read.Name as category but it doesnt give me "TEAC". I dont
get
| any value in the msgbox. It is blank. Am I missing something?
|
| I see the value for city which is "VICTORIA" but the reader.Name is "".
|
| thanks for you help,
|
| Will
|
|

[Cor Ligthert]

Wk6Pack,

I checked it, your file is a normal dataset. When you open in the designer
as item an XML file and than paste your data in, than it will create for you
a dataset. When you than go to Data view below on the page, than you see a
kind of datagrid.

You can process this file as a normal dataset with
dim ds as new dataset
ds.readxml("myf ile")

To get the values from by instance non strongly typed. (what you can
generate as well by right clicking on that datagrid and than do generate
dataset). However beneath non strongly typed. Than the first category from
employee is

Dim mystring as string = ds.tables("empl oyee").Rows(0)( "category")
'be aware that those columnames are case sensitive.

I hope this helps,

Cor

[M. Posseth]

As extra tip to Cor`s thought about putting the data in a dataset

dim currxml="
<employee><addr ess_2></address_2><assi gnments><assign ment><assigned_ bargaini
ng_unit></assigned_bargai ning_unit><assi gned_department ></assigned_depart men
t><assigned_loc ations><assigne d_location></assigned_locati on></assigned_loca
tions><assigned _position></assigned_positi on><assigned_po sition_departme nt><
/assigned_positi on_department></assignment></assignments><ca tegory>TEAC</cat
egory><city>VIC TORIA</city><country_c ode>CAN</country_code><d emographic_barg
aining_unit></demographic_bar gaining_unit><d emographic_depa rtment></demograp
hic_department> <demographic_lo cation></demographic_loc ation><demograp hic_pos
ition></demographic_pos ition><email></email><employee _no>202307</employee_no

<fax_no></fax_no><first_n ame>MURIEL</first_name><las t_name>ANDREWS</last_na me><middle_name ></middle_name><mo st_assigned_bar gaining_unit></most_assigned
_bargaining_uni t><most_assigne d_department></most_assigned_d epartment><most _
assigned_locati on></most_assigned_l ocation><most_a ssigned_positio n></most_as
signed_position ><most_assigned _position_depar tment></most_assigned_p osition_
department><pos tal_code>V8S
5G5</postal_code><pr eferred_name></preferred_name> <province_code> BC</provinc
e_code><salutat ion>MS</salutation><sin >706257185</sin><status>T</status><str
eet>1050 DEAL STREET</street><telepho ne_no></telephone_no></employee>"
Dim xmldoc As New XmlDocument

xmldoc.LoadXml( currxml)

Dim XMLnr As New XmlNodeReader(X mldoc.SelectSin gleNode("employ ee"))

Dim ds As New DataSet

ds.ReadXml(XMLn r)

Dim ds As New DataSet

ds.ReadXml(XMLn r)

'to prove that it works throw a datagrid on the form

DataGrid1.DataS ource = ds

happy coding :-)

M. Posseth [MCP Developer]
"Cor Ligthert" <no************ @planet.nl> wrote in message
news:OJ******** ******@TK2MSFTN GP15.phx.gbl... Wk6Pack,

I checked it, your file is a normal dataset. When you open in the designer
as item an XML file and than paste your data in, than it will create for you a dataset. When you than go to Data view below on the page, than you see a
kind of datagrid.

You can process this file as a normal dataset with
dim ds as new dataset
ds.readxml("myf ile")

To get the values from by instance non strongly typed. (what you can
generate as well by right clicking on that datagrid and than do generate
dataset). However beneath non strongly typed. Than the first category from
employee is

Dim mystring as string = ds.tables("empl oyee").Rows(0)( "category")
'be aware that those columnames are case sensitive.

I hope this helps,

Cor

[wk6pack]

Thanks Cor, Jay and M. Posseth. I now understand it a bit better.

Will
"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in message
news:u2******** ******@TK2MSFTN GP12.phx.gbl...

wk6pack,
| I would like to know how to parse the following xml string using vb.net?
I would "parse" it with either a XmlTextReader, XmlDocument, or
XPathDocument, something like:

Dim currxml As String = ...

Dim input As New StringReader(cu rrxml)

Dim reader As New XmlTextReader(i nput)

If I loaded the string into an XmlDocument or an XPathDocument, I would use the various methods on those objects (such as Select) to extract the content that I need. Rarely would I "hand it back" to an XmlNodeReader.. .

| I do see the read.Name as category but it doesnt give me "TEAC". I dont
get
| any value in the msgbox. It is blank. Am I missing something?

Yes, you are confusing an Element Node with a Text Node. "<category> " is an Element node, while "TEAC" is a Text Node which happens to be the contents
of the "<category> " Element node

| I see the value for city which is "VICTORIA" but the reader.Name is "".
Again, "VICTORIA" is a Text Node, which happens to be the contents of a
"<category> " Element node.

To see the different between the various node types, try:

Dim currxml As String = ...
Dim input As New StringReader(cu rrxml)
Dim reader As New XmlTextReader(i nput)

While reader.Read
Debug.WriteLine (reader.NodeTyp e, "node type")
Debug.WriteLine (reader.Prefix, "prefix")
Debug.WriteLine (reader.LocalNa me, "local name")
Debug.WriteLine (reader.Name, "name")
Debug.WriteLine (reader.Namespa ceURI, "namespace" )
Debug.WriteLine (reader.Value, "value")
Debug.WriteLine (Nothing)
End While

Hope this helps
Jay
"wk6pack" <wk***@sd61.bc. ca> wrote in message
news:O5******** ******@tk2msftn gp13.phx.gbl...
| Hi,
|
| I would like to know how to parse the following xml string using vb.net?
| currxml="
|
<employee><addr ess_2></address_2><assi gnments><assign ment><assigned_ bargaini |
ng_unit></assigned_bargai ning_unit><assi gned_department ></assigned_depart men |
t><assigned_loc ations><assigne d_location></assigned_locati on></assigned_loca |
tions><assigned _position></assigned_positi on><assigned_po sition_departme nt>< |
/assigned_positi on_department></assignment></assignments><ca tegory>TEAC</cat |
egory><city>VIC TORIA</city><country_c ode>CAN</country_code><d emographic_barg |
aining_unit></demographic_bar gaining_unit><d emographic_depa rtment></demograp |
hic_department> <demographic_lo cation></demographic_loc ation><demograp hic_pos |
ition></demographic_pos ition><email></email><employee _no>202307</employee_no |

<fax_no></fax_no><first_n ame>MURIEL</first_name><las t_name>ANDREWS</last_na
|
me><middle_name ></middle_name><mo st_assigned_bar gaining_unit></most_assigned |
_bargaining_uni t><most_assigne d_department></most_assigned_d epartment><most _ |
assigned_locati on></most_assigned_l ocation><most_a ssigned_positio n></most_as |
signed_position ><most_assigned _position_depar tment></most_assigned_p osition_ | department><pos tal_code>V8S
|
5G5</postal_code><pr eferred_name></preferred_name> <province_code> BC</provinc |
e_code><salutat ion>MS</salutation><sin >706257185</sin><status>T</status><str | eet>1050 DEAL STREET</street><telepho ne_no></telephone_no></employee>"
|
| here is my code so far:
| Dim strreader = New StringReader(cu rrxml)
|
| Dim xmldoc As New XmlDocument
|
| xmldoc.LoadXml( currxml)
|
| reader = New XmlNodeReader(x mldoc)
|
| While reader.Read
|
| Select Case reader.NodeType
|
| Case XmlNodeType.Ele ment
|
| If reader.Name = "category" Then
|
| MsgBox(reader.N ame)
|
| End If
|
| End Select
|
| End While
|
|
|
| I do see the read.Name as category but it doesnt give me "TEAC". I dont
get
| any value in the msgbox. It is blank. Am I missing something?
|
| I see the value for city which is "VICTORIA" but the reader.Name is "".
|
| thanks for you help,
|
| Will
|
|

[wk6pack]

thanks Cor, M. Posseth and Jay.

Will
"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in message
news:u2******** ******@TK2MSFTN GP12.phx.gbl...

wk6pack,
| I would like to know how to parse the following xml string using vb.net?
I would "parse" it with either a XmlTextReader, XmlDocument, or
XPathDocument, something like:

Dim currxml As String = ...

Dim input As New StringReader(cu rrxml)

Dim reader As New XmlTextReader(i nput)

If I loaded the string into an XmlDocument or an XPathDocument, I would use the various methods on those objects (such as Select) to extract the content that I need. Rarely would I "hand it back" to an XmlNodeReader.. .

| I do see the read.Name as category but it doesnt give me "TEAC". I dont
get
| any value in the msgbox. It is blank. Am I missing something?

Yes, you are confusing an Element Node with a Text Node. "<category> " is an Element node, while "TEAC" is a Text Node which happens to be the contents
of the "<category> " Element node

| I see the value for city which is "VICTORIA" but the reader.Name is "".
Again, "VICTORIA" is a Text Node, which happens to be the contents of a
"<category> " Element node.

To see the different between the various node types, try:

Dim currxml As String = ...
Dim input As New StringReader(cu rrxml)
Dim reader As New XmlTextReader(i nput)

While reader.Read
Debug.WriteLine (reader.NodeTyp e, "node type")
Debug.WriteLine (reader.Prefix, "prefix")
Debug.WriteLine (reader.LocalNa me, "local name")
Debug.WriteLine (reader.Name, "name")
Debug.WriteLine (reader.Namespa ceURI, "namespace" )
Debug.WriteLine (reader.Value, "value")
Debug.WriteLine (Nothing)
End While

Hope this helps
Jay
"wk6pack" <wk***@sd61.bc. ca> wrote in message
news:O5******** ******@tk2msftn gp13.phx.gbl...
| Hi,
|
| I would like to know how to parse the following xml string using vb.net?
| currxml="
|
<employee><addr ess_2></address_2><assi gnments><assign ment><assigned_ bargaini |
ng_unit></assigned_bargai ning_unit><assi gned_department ></assigned_depart men |
t><assigned_loc ations><assigne d_location></assigned_locati on></assigned_loca |
tions><assigned _position></assigned_positi on><assigned_po sition_departme nt>< |
/assigned_positi on_department></assignment></assignments><ca tegory>TEAC</cat |
egory><city>VIC TORIA</city><country_c ode>CAN</country_code><d emographic_barg |
aining_unit></demographic_bar gaining_unit><d emographic_depa rtment></demograp |
hic_department> <demographic_lo cation></demographic_loc ation><demograp hic_pos |
ition></demographic_pos ition><email></email><employee _no>202307</employee_no |

<fax_no></fax_no><first_n ame>MURIEL</first_name><las t_name>ANDREWS</last_na
|
me><middle_name ></middle_name><mo st_assigned_bar gaining_unit></most_assigned |
_bargaining_uni t><most_assigne d_department></most_assigned_d epartment><most _ |
assigned_locati on></most_assigned_l ocation><most_a ssigned_positio n></most_as |
signed_position ><most_assigned _position_depar tment></most_assigned_p osition_ | department><pos tal_code>V8S
|
5G5</postal_code><pr eferred_name></preferred_name> <province_code> BC</provinc |
e_code><salutat ion>MS</salutation><sin >706257185</sin><status>T</status><str | eet>1050 DEAL STREET</street><telepho ne_no></telephone_no></employee>"
|
| here is my code so far:
| Dim strreader = New StringReader(cu rrxml)
|
| Dim xmldoc As New XmlDocument
|
| xmldoc.LoadXml( currxml)
|
| reader = New XmlNodeReader(x mldoc)
|
| While reader.Read
|
| Select Case reader.NodeType
|
| Case XmlNodeType.Ele ment
|
| If reader.Name = "category" Then
|
| MsgBox(reader.N ame)
|
| End If
|
| End Select
|
| End While
|
|
|
| I do see the read.Name as category but it doesnt give me "TEAC". I dont
get
| any value in the msgbox. It is blank. Am I missing something?
|
| I see the value for city which is "VICTORIA" but the reader.Name is "".
|
| thanks for you help,
|
| Will
|
|