Solved

Skip root node when reading XML file using XML Read vb.net/c#

Posted on 2014-01-09
1
1,400 Views
Last Modified: 2014-01-09
Hi Guys,

I have the below code that works fine in creating a data set which populates my grid control. However I would like to skip the root node so that my data is only the child columns and its data.

 Dim web As New WebClient()
            Dim url As String = String.Format("myurltoerbsiteapi")
            Dim response As String = web.DownloadString(url)
            Dim ds As New DataSet()
            Using stringReader As New StringReader(response)
                ds = New DataSet()
                ds.ReadXml(stringReader)
            End Using
            dt = ds.Tables(0)

            Me.GridControl1.DataSource = dt

Open in new window


The returned XML from website looks like so;

<?xml version="1.0" encoding="UTF-8"?>
<results xmlns="http://companycheck.co.uk/api/search" searchTerm="databarracks" total="2"><company id="FC031496"><name>DATABARRACKS LIMITED</name><number>FC031496</number><status>Active</status><address>TOWER HILL HOUSE, 32-34 LE BORDAGE, GUERNSEY, GY1 1BP</address><country>GB</country></company><company id="04533716"><name>DATABARRACKS (UK) LTD</name><number>04533716</number><status>Active</status><address>ARXCIS HOUSE 9 PARK HILL, LONDON, SW4 9NS</address><country>GB</country></company></results>

Open in new window


I would like to read it like so in my code:

<?xml version="1.0" encoding="UTF-8"?>
<company id="FC031496"><name>DATABARRACKS LIMITED</name><number>FC031496</number><status>Active</status><address>TOWER HILL HOUSE, 32-34 LE BORDAGE, GUERNSEY, GY1 1BP</address><country>GB</country></company><company id="04533716"><name>DATABARRACKS (UK) LTD</name><number>04533716</number><status>Active</status><address>ARXCIS HOUSE 9 PARK HILL, LONDON, SW4 9NS</address><country>GB</country></company>

Open in new window


Therefore I need  way to skip the <results> root node from being read

Your help is much appreciated
0
Comment
Question by:databarracks
1 Comment
 

Accepted Solution

by:
databarracks earned 0 total points
ID: 39770307
Never mind I found my solution which was to use the node as the table name like ds.Tables("table_name").
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

680 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