Solved

parse XML using VB.NET

Posted on 2013-01-29
3
675 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
ID: 38832777
0
 
LVL 13

Accepted Solution

by:
jonnidip earned 500 total points
ID: 38834309
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
ID: 38843856
thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

867 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

21 Experts available now in Live!

Get 1:1 Help Now