472,334 Members | 1,531 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

home > topics > visual basic .net > questions > parsing a string as xml using vb.net

Join Bytes to post your question to a community of 472,334 software developers and data experts.

parsing a string as XML using VB.NET

Hi,

I would like to know how to parse the following xml string using vb.net?
currxml="
<employee><address_2></address_2><assignments><assignment><assigned_barga ini
ng_unit></assigned_bargaining_unit><assigned_department></assigned_departmen
t><assigned_locations><assigned_location></assigned_location></assigned_loca
tions><assigned_position></assigned_position><assigned_position_department><
/assigned_position_department></assignment></assignments><category>TEAC</cat
egory><city>VICTORIA</city><country_code>CAN</country_code><demographic_barg
aining_unit></demographic_bargaining_unit><demographic_departmen t></demograp
hic_department><demographic_location></demographic_location><demographic_pos
ition></demographic_position><email></email><employee_no>202307</employee_no
<fax_no></fax_no><first_name>MURIEL</first_name><last_name>ANDREWS</last_na

me><middle_name></middle_name><most_assigned_bargaining_unit></most_assigned
_bargaining_unit><most_assigned_department></most_assigned_department><most_
assigned_location></most_assigned_location><most_assigned_position></most_as
signed_position><most_assigned_position_department ></most_assigned_position_
department><postal_code>V8S
5G5</postal_code><preferred_name></preferred_name><province_code>BC</provinc
e_code><salutation>MS</salutation><sin>706257185</sin><status>T</status><str
eet>1050 DEAL STREET</street><telephone_no></telephone_no></employee>"

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

Dim xmldoc As New XmlDocument

xmldoc.LoadXml(currxml)

reader = New XmlNodeReader(xmldoc)

While reader.Read

Select Case reader.NodeType

Case XmlNodeType.Element

If reader.Name = "category" Then

MsgBox(reader.Name)

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
Nov 21 '05 #1
7 18021
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
Nov 21 '05 #2
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**************@TK2MSFTNGP14.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

Nov 21 '05 #3
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(currxml)

Dim reader As New XmlTextReader(input)

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(currxml)
Dim reader As New XmlTextReader(input)

While reader.Read
Debug.WriteLine(reader.NodeType, "node type")
Debug.WriteLine(reader.Prefix, "prefix")
Debug.WriteLine(reader.LocalName, "local name")
Debug.WriteLine(reader.Name, "name")
Debug.WriteLine(reader.NamespaceURI, "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**************@tk2msftngp13.phx.gbl...
| Hi,
|
| I would like to know how to parse the following xml string using vb.net?
| currxml="
|
<employee><address_2></address_2><assignments><assignment><assigned_barga ini
|
ng_unit></assigned_bargaining_unit><assigned_department></assigned_departmen
|
t><assigned_locations><assigned_location></assigned_location></assigned_loca
|
tions><assigned_position></assigned_position><assigned_position_department><
|
/assigned_position_department></assignment></assignments><category>TEAC</cat
|
egory><city>VICTORIA</city><country_code>CAN</country_code><demographic_barg
|
aining_unit></demographic_bargaining_unit><demographic_departmen t></demograp
|
hic_department><demographic_location></demographic_location><demographic_pos
|
ition></demographic_position><email></email><employee_no>202307</employee_no
|
<fax_no></fax_no><first_name>MURIEL</first_name><last_name>ANDREWS</last_na

|
me><middle_name></middle_name><most_assigned_bargaining_unit></most_assigned
|
_bargaining_unit><most_assigned_department></most_assigned_department><most_
|
assigned_location></most_assigned_location><most_assigned_position></most_as
|
signed_position><most_assigned_position_department ></most_assigned_position_
| department><postal_code>V8S
|
5G5</postal_code><preferred_name></preferred_name><province_code>BC</provinc
|
e_code><salutation>MS</salutation><sin>706257185</sin><status>T</status><str
| eet>1050 DEAL STREET</street><telephone_no></telephone_no></employee>"
|
| here is my code so far:
| Dim strreader = New StringReader(currxml)
|
| Dim xmldoc As New XmlDocument
|
| xmldoc.LoadXml(currxml)
|
| reader = New XmlNodeReader(xmldoc)
|
| While reader.Read
|
| Select Case reader.NodeType
|
| Case XmlNodeType.Element
|
| If reader.Name = "category" Then
|
| MsgBox(reader.Name)
|
| 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
|
|
Nov 21 '05 #4
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("myfile")

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("employee").Rows(0)("category")
'be aware that those columnames are case sensitive.

I hope this helps,

Cor

Nov 21 '05 #5
As extra tip to Cor`s thought about putting the data in a dataset

dim currxml="
<employee><address_2></address_2><assignments><assignment><assigned_barga ini
ng_unit></assigned_bargaining_unit><assigned_department></assigned_departmen
t><assigned_locations><assigned_location></assigned_location></assigned_loca
tions><assigned_position></assigned_position><assigned_position_department><
/assigned_position_department></assignment></assignments><category>TEAC</cat
egory><city>VICTORIA</city><country_code>CAN</country_code><demographic_barg
aining_unit></demographic_bargaining_unit><demographic_departmen t></demograp
hic_department><demographic_location></demographic_location><demographic_pos
ition></demographic_position><email></email><employee_no>202307</employee_no
<fax_no></fax_no><first_name>MURIEL</first_name><last_name>ANDREWS</last_na me><middle_name></middle_name><most_assigned_bargaining_unit></most_assigned
_bargaining_unit><most_assigned_department></most_assigned_department><most_
assigned_location></most_assigned_location><most_assigned_position></most_as
signed_position><most_assigned_position_department ></most_assigned_position_
department><postal_code>V8S
5G5</postal_code><preferred_name></preferred_name><province_code>BC</provinc
e_code><salutation>MS</salutation><sin>706257185</sin><status>T</status><str
eet>1050 DEAL STREET</street><telephone_no></telephone_no></employee>"
Dim xmldoc As New XmlDocument

xmldoc.LoadXml(currxml)

Dim XMLnr As New XmlNodeReader(Xmldoc.SelectSingleNode("employee"))

Dim ds As New DataSet

ds.ReadXml(XMLnr)

Dim ds As New DataSet

ds.ReadXml(XMLnr)

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

DataGrid1.DataSource = ds

happy coding :-)

M. Posseth [MCP Developer]
"Cor Ligthert" <no************@planet.nl> wrote in message
news:OJ**************@TK2MSFTNGP15.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("myfile")

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("employee").Rows(0)("category")
'be aware that those columnames are case sensitive.

I hope this helps,

Cor

Nov 21 '05 #6
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**************@TK2MSFTNGP12.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(currxml)

Dim reader As New XmlTextReader(input)

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(currxml)
Dim reader As New XmlTextReader(input)

While reader.Read
Debug.WriteLine(reader.NodeType, "node type")
Debug.WriteLine(reader.Prefix, "prefix")
Debug.WriteLine(reader.LocalName, "local name")
Debug.WriteLine(reader.Name, "name")
Debug.WriteLine(reader.NamespaceURI, "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**************@tk2msftngp13.phx.gbl...
| Hi,
|
| I would like to know how to parse the following xml string using vb.net?
| currxml="
|
<employee><address_2></address_2><assignments><assignment><assigned_barga ini |
ng_unit></assigned_bargaining_unit><assigned_department></assigned_departmen |
t><assigned_locations><assigned_location></assigned_location></assigned_loca |
tions><assigned_position></assigned_position><assigned_position_department>< |
/assigned_position_department></assignment></assignments><category>TEAC</cat |
egory><city>VICTORIA</city><country_code>CAN</country_code><demographic_barg |
aining_unit></demographic_bargaining_unit><demographic_departmen t></demograp |
hic_department><demographic_location></demographic_location><demographic_pos |
ition></demographic_position><email></email><employee_no>202307</employee_no |

<fax_no></fax_no><first_name>MURIEL</first_name><last_name>ANDREWS</last_na
|
me><middle_name></middle_name><most_assigned_bargaining_unit></most_assigned |
_bargaining_unit><most_assigned_department></most_assigned_department><most_ |
assigned_location></most_assigned_location><most_assigned_position></most_as |
signed_position><most_assigned_position_department ></most_assigned_position_ | department><postal_code>V8S
|
5G5</postal_code><preferred_name></preferred_name><province_code>BC</provinc |
e_code><salutation>MS</salutation><sin>706257185</sin><status>T</status><str | eet>1050 DEAL STREET</street><telephone_no></telephone_no></employee>"
|
| here is my code so far:
| Dim strreader = New StringReader(currxml)
|
| Dim xmldoc As New XmlDocument
|
| xmldoc.LoadXml(currxml)
|
| reader = New XmlNodeReader(xmldoc)
|
| While reader.Read
|
| Select Case reader.NodeType
|
| Case XmlNodeType.Element
|
| If reader.Name = "category" Then
|
| MsgBox(reader.Name)
|
| 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
|
|

Nov 21 '05 #7
thanks Cor, M. Posseth and Jay.

Will
"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:u2**************@TK2MSFTNGP12.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(currxml)

Dim reader As New XmlTextReader(input)

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(currxml)
Dim reader As New XmlTextReader(input)

While reader.Read
Debug.WriteLine(reader.NodeType, "node type")
Debug.WriteLine(reader.Prefix, "prefix")
Debug.WriteLine(reader.LocalName, "local name")
Debug.WriteLine(reader.Name, "name")
Debug.WriteLine(reader.NamespaceURI, "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**************@tk2msftngp13.phx.gbl...
| Hi,
|
| I would like to know how to parse the following xml string using vb.net?
| currxml="
|
<employee><address_2></address_2><assignments><assignment><assigned_barga ini |
ng_unit></assigned_bargaining_unit><assigned_department></assigned_departmen |
t><assigned_locations><assigned_location></assigned_location></assigned_loca |
tions><assigned_position></assigned_position><assigned_position_department>< |
/assigned_position_department></assignment></assignments><category>TEAC</cat |
egory><city>VICTORIA</city><country_code>CAN</country_code><demographic_barg |
aining_unit></demographic_bargaining_unit><demographic_departmen t></demograp |
hic_department><demographic_location></demographic_location><demographic_pos |
ition></demographic_position><email></email><employee_no>202307</employee_no |

<fax_no></fax_no><first_name>MURIEL</first_name><last_name>ANDREWS</last_na
|
me><middle_name></middle_name><most_assigned_bargaining_unit></most_assigned |
_bargaining_unit><most_assigned_department></most_assigned_department><most_ |
assigned_location></most_assigned_location><most_assigned_position></most_as |
signed_position><most_assigned_position_department ></most_assigned_position_ | department><postal_code>V8S
|
5G5</postal_code><preferred_name></preferred_name><province_code>BC</provinc |
e_code><salutation>MS</salutation><sin>706257185</sin><status>T</status><str | eet>1050 DEAL STREET</street><telephone_no></telephone_no></employee>"
|
| here is my code so far:
| Dim strreader = New StringReader(currxml)
|
| Dim xmldoc As New XmlDocument
|
| xmldoc.LoadXml(currxml)
|
| reader = New XmlNodeReader(xmldoc)
|
| While reader.Read
|
| Select Case reader.NodeType
|
| Case XmlNodeType.Element
|
| If reader.Name = "category" Then
|
| MsgBox(reader.Name)
|
| 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
|
|

Nov 21 '05 #8
New Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
PEP 321: Date/Time Parsing and Formatting
by: Gerrit Holl | last post by:
Posted with permission from the author. I have some comments on this PEP, see the (coming) followup to this message. PEP: 321 Title: Date/Time...
Python
6
Parsing out SQL statement
by: BerkshireGuy | last post by:
Does anyone know of a good function that will parse out parts of an SQL statement that is passed to it in seperate variables? It should be able...
Microsoft Access / VBA
50
parsing date string
by: z. f. | last post by:
HI, i have string in format dd/mm/yyyyy hh:mm:ss and giving this as an input to DateTime.Parse gives a string was not recognized as a valid date...
Visual Basic .NET
3
parsing an ifstream to get some specific text
by: toton | last post by:
Hi, I have some ascii files, which are having some formatted text. I want to read some section only from the total file. For that what I am doing...
C / C++
9
Need help with parsing a multilined log file into objects
by: Paulers | last post by:
Hello, I have a log file that contains many multi-line messages. What is the best approach to take for extracting data out of each message and...
Visual Basic .NET
3
Strange!! Unexpected end of file while parsing Name has occurred
by: Anup Daware | last post by:
Hi Group, I am facing a strange problem here: I am trying to read xml response from a servlet using XmlTextWriter. I am able to read the read...
ASP.NET
3
A nice way to use regex for complicate parsing
by: aspineux | last post by:
My goal is to write a parser for these imaginary string from the SMTP protocol, regarding RFC 821 and 1869. I'm a little flexible with the BNF from...
Python
2
Parsing Buffer Data
by: RG | last post by:
I am having trouble parsing the data I need from a Serial Port Buffer. I am sending info to a microcontroller that is being echoed back that I...
Visual Basic .NET
6
Parsing - is this a sensible idea?
by: gw7rib | last post by:
I have a program that needs to do a small amount of relatively simple parsing. The routines I've written work fine, but the code using them is a...
C / C++
1
String converting to Stack/ Parsing
by: eyeore | last post by:
Hello everyone my String reverse code works but my professor wants me to use pop top push or Stack code and parsing code could you please teach me...
Java
0
Benefits of Blockchain App Development for Enterprise Businesses
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
General
0
How to minimize a tool bar that shows up when in reports
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
General
0
how to collapse a custom toolbar in VBA
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
General
0
Basic concepts of WebLogic Admin training?
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
Oracle Database
0
jalbright99669
https redirect with reverse proxy
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
IIS / Internet Information Server
0
How to layout php header location with a variable as the location?
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
PHP
2
How to use http requests (Get function) to get variable value?
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
Python
0
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
General
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
General

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2023
About Bytes
Advertise
Terms Of Use
Privacy Policy

Sitemap

Follow us! Get the Latest Bytes Updates