Solved

parse XML using VB.NET

Posted on 2013-01-29

1 solution

689 Views

Last Modified: 2013-02-01

Can anyone tell me how to parse the attached XML using VB.NET? I need to extract the lat and lng node values from the parent location node, that in turn has a parent node of geometry.
xxx.xml

Comment

Question by:HLRosenberger

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

3 Comments

LVL 83

Expert Comment

by:CodeCruiser

ID: 388327772013-01-29

Examples

http://vb.net-informations.com/xml/open-xml-vb.net.htm

http://www.codeproject.com/Articles/4826/XML-File-Parsing-in-VB-NET

http://msdn.microsoft.com/en-us/library/cc189056(v=vs.95).aspx

LVL 13

Accepted Solution

by:jonnidip

jonnidip earned 500 total points

ID: 388343092013-01-30

The easiest way is to load it into a DataSet.
Here is a sample:

Dim ds As New DataSet()
ds.ReadXml("d:\xxx.xml")

Open in new window

You may find that the DataSet will contain as many DataTable objects as xml nodes.
You can then cycle tables to get your values.

Regards.

LVL 1

Author Closing Comment

by:HLRosenberger

ID: 388438562013-02-01

thanks

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

VB.Net To Excel Usual Stuff

Article by: Avinash

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …

Visual Basic.NET

T-SQL: Normalized data to a single comma delineated string and back

Article by: Jim

Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa. Here's how to do it.

Network monitoring: how to automate fixing common network or server issues?

Video by: AdRem

Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

display Triangles! and Circles! in a Microsoft Access Query -- Get Previous Record too

Video by: crystal

Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…