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

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
databarracksAsked:
Who is Participating?
 
databarracksConnect With a Mentor Author Commented:
Never mind I found my solution which was to use the node as the table name like ds.Tables("table_name").
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.