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
<?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>