Question about dataset readxml method

[Raymond Du]

Hi,

I am using Dataset's ReadXML method to read an XML file. Here i s my code
snippet:

Dim dsTemp As New DataSet
dsTemp.ReadXml( Server.MapPath( "~/data3.xml"))

and data3.xml as follow:
<myDataSet>
<LeftMenu>
<MenuItem>
<Title>Enter Customer</Title>
<Action>Sid</Action>
</MenuItem>
<MenuItem>
<Title>Enter Contact</Title>
<Action>Sid</Action>
</MenuItem>
<MenuItem>
<Title>Enter City</Title>
<Action>Sid</Action>
</MenuItem>
<MenuItem>
<Title>Enter City</Title>
<Action>Sid</Action>
</MenuItem>
</LeftMenu>
</myDataSet>
After readXML statement, dsTemp.tables.c ount is 2, I am expecting only 1.
The one that has all XML content is dsTemp.tables(1 ), can any one explain
why there is another table?

TIA

[Rak]

Hi Ray,
This is exactly how the parsing happens in dataset.ReadXML method. Each
node with children will be added as a table to the dataset. So in your case
LeftMenu will be added as a table and then MenuItem table. If you check the
relationship (ds.Relations) you will find a parent-child relationship between
these two tables.

Hope this helps.

rgds,
Rakesh

"Raymond Du" wrote:

Hi,

I am using Dataset's ReadXML method to read an XML file. Here i s my code
snippet:

Dim dsTemp As New DataSet
dsTemp.ReadXml( Server.MapPath( "~/data3.xml"))

and data3.xml as follow:
<myDataSet>
<LeftMenu>
<MenuItem>
<Title>Enter Customer</Title>
<Action>Sid</Action>
</MenuItem>
<MenuItem>
<Title>Enter Contact</Title>
<Action>Sid</Action>
</MenuItem>
<MenuItem>
<Title>Enter City</Title>
<Action>Sid</Action>
</MenuItem>
<MenuItem>
<Title>Enter City</Title>
<Action>Sid</Action>
</MenuItem>
</LeftMenu>
</myDataSet>
After readXML statement, dsTemp.tables.c ount is 2, I am expecting only 1.
The one that has all XML content is dsTemp.tables(1 ), can any one explain
why there is another table?

TIA