ReadXml for DataSet chokes if the root element has an attribute?

[KJ]

I have an easy xml document, for example:


<pics>
<pic name="foo"/>
<pic name="bar"/>
</pics>


I call ReadXML on my DataSet, and no problems (2 rows, one for each pic

element), one column for the name attribute.


However, if the Xml looks like this:


<pics attr="why">
<pic name="foo"/>
<pic name="bar"/>
</pics>


ReadXml only creates a 1 row table with the pics attribute "attr" as
its only column (ignoring the pic children).

So really, I have 2 questions:

Is it possible to control how ReadXml infers rows from Xml at runtime?

How to do so?

-TIA

 

[Dmytro Lapshyn [MVP]]

Hi KJ,

The detailed information on inferring DataSet schema from XML can be found
in the following MSDN topic:

"Inferring DataSet Relational Structure from XML" (.NET Framework
Developer's Guide)

 

[KJ]

Got it. Very helpful docs. I wasted half a day guessing at what the
rules were and tweaking the Xml. Now I know what ReadXml will do with
various Xml.