Hi,

I am trying to create the datset from the following xmlstring. The only unique thing    about the xml is it has two similar child node version with different values for the parent  node object. when i look at the column returned from the dataset, it doesnot contain the column for the repeating nodes. version 

string xml = "<?xml version=\"1.0\"?>\n<root>\n

<object >\n

<version>1.0</version>\n

<version>CURRENT<version>\n

<object_id>123</object_id>\n

<object_name>Documnet</object_name>\n

</object>\n</root>\n";

StringReader xmlSR = new StringReader(xml);

DataSet dsInbox = new DataSet();

dsInbox.ReadXml(xmlSR, XmlReadMode.Auto); return dsInbox;

If it is an option I would redesign your XML schema and name the 2nd Version node something else.  It doesn't really make any sense to have two sibling nodes with the same name and different datatypes.  You would never design a database table that way, why do it with an XML file?

hi Ryan,

Thanks for the reply,I would agree that you should not design in such a way.but i am getting this from the object model exposed by the one of the products that my client is using and i have no control over the database. i can only interact with the database using exposed object model, which gives me the xml in the above format.

Thanks

Gaurav

Ok, when I ran this the first problem I ran into was that your 2nd version node is missing the closing /

You have <version>CURRENT<version>

Instead of <version>CURRENT</version>

After correcting that The datatable that is returned has the column in it.  Specifically my DataTable contained the columns:

version
version_Text

Sorry, that does not fix the problem, you actually get two DataTables back, and one is just named version.

I would suggest a couple possible solutions that aren't ideal but should work.

1.  Use a regular expression to change the name of the 2nd node in the xml string, so you can read it using InferSchema and everything should come out OK.

2.  Create your DataTable by hand, use an XmlDocument object, traverse the document manually and populate the DataTable.

sawhneyg:

 am getting this from the object model exposed by the one of the products that my client is using and i have no control over the database. i can only interact with the database using exposed object model, which gives me the xml in the above format.

After you receive this XML you can write XSLT over it and transofm the xml the way you want.

there could be a possibility where any number of repeating nodes can appear, is there a generic way to handle when there are repeating nodes, convert them into a single node with values separated by comma.  

yahh you could wrtite xslt which would do the same thing for u.... 

try this to get the data in dataset

DataSet authorsDataSet;
        string filePath = Server.MapPath("grid.xml");
        authorsDataSet = new DataSet();
        //Read the contents of the XML file into the DataSet
        authorsDataSet.ReadXml(filePath);