same table cannot be the child table in two nested relations

[Guest]

i get the following error while reading an xml into a dataset
The same table cannot be the child table in two nested relation

is there a solution for it

 

[Mohamoss]

hi
i think has to do with the scheme of your xml.... would you send the
structure of the file you are tring to read

 

[Peter Bromberg [C# MVP]]

The dataSet is doing its best to infer a schema when reading your Xml
document, and it's finding two sets of elements with the same name, and
doesn't know how to handle it.

Experiment if you can with changing the name of one of the sets of elements
and the error will go away.
This is very common when reading Xml that doesn't correspond to the expected
Schema for a DataSet.
--Peter

 

[Guest]

i know it the follwing does not correspod to Xml Schema for a DataSet. is there another approach that i can use to get this workin

<Message><MessageHeader ><Total><Money currency=&quot;CAD&quot;>23433.0</Money></Total></MessageHeader><ItemIn quantity=&quot;1&quot;><ItemDetail><UnitPrice><Money currency=&quot;CAD&quot;>17400.0</Money></UnitPrice><Description >XXX</Description><UnitOfMeasure>EA</UnitOfMeasure><Classification>43222609</Classification></ItemDetail></ItemIn></Message>