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

I think the article you need may be this:

http://msdn.microsoft.com/library/de...ionfromxml.asp


"harry" <(E-Mail Removed)> wrote in message
news:3f4b828e$(E-Mail Removed)...
> 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
>
>