Solved

parse XML using VB.NET

Posted on 2013-01-29
3
671 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
0
Comment
Question by:HLRosenberger
3 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
Comment Utility
0
 
LVL 13

Accepted Solution

by:
jonnidip earned 500 total points
Comment Utility
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.
0
 
LVL 1

Author Closing Comment

by:HLRosenberger
Comment Utility
thanks
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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 …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video discusses moving either the default database or any database to a new volume.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now