databarracks
asked on
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.
The returned XML from website looks like so;
I would like to read it like so in my code:
Therefore I need way to skip the <results> root node from being read
Your help is much appreciated
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
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>
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>
Therefore I need way to skip the <results> root node from being read
Your help is much appreciated
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.