Restrictions on xml format to create datasets?

  • Thread starter Thread starter harry
  • Start date Start date
H

harry

Hello,

I've been looking into this all day but can find no reference related to
this. We have a legacy com object which returns back data from a datasource
in an xml format, similar to the following:

<rows>
<row>
<column name="OrderNo" security="0">
<value>1</value>
</column>
<column name="OrderName" security="32">
<value>flowers</value>
</column>
<column name="Cost" security="0">
<value>10.50</value>
</column>
</row>
<row>
<column name="OrderNo" security="0">
<value>2</value>
</column>
<column name="OrderName" security="32">
<value>car</value>
</column>
<column name="Cost" security="0">
<value>5000</value>
</column>
</row>
</rows>

(where name is the column name, security is whether editable or not, and
value is the value of the cell)

Is there any simple way of converting this xml structure into a dataset or
are we likely to have to create our own dataset object to pass into the
datagrid/create some xsl transformations to convert it into another form?

Oh we do have the metadata for each column by this point so it is easier
enough to create an xsd with this information but we cannot figure out it's
structure so a dataset would be filled correctly.

cheers for any suggestions anyone can put this way.

Harry
 
Back
Top