xml and data sets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Diogo Alves - Software Developer - 12 Dec 2005 11:56 GMT

Hi,

I am trying to put some XXL comde in a database column, and I am using a
dataset to edit it...

let's imagine this scenario

<?xml version = "1.0"?>
<root>
<class>
<student studentID="13429" name = "John"/>
<student studentID="13430" name = "Mary"/>
</class>
</root>

I can manipulate at easy everything except creating students inside the
class...

How can I do it using a DataSet?

Reply to this Message

Kevin Spencer - 12 Dec 2005 14:59 GMT

Create a DataSet with a single DataTable in it. Add the columns necessary to
the DataTable, and set the type of each column. Then read each "student"
element in the XML file, getting the attribute values from the element, and
reading them into a new row in the DataTable for each element, putting each
attribute value into the appropriate column.

Signature

HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
You can lead a fish to a bicycle,
but you can't make it stink.

> Hi,
>
[quoted text clipped - 15 lines]
>
> How can I do it using a DataSet?

Reply to this Message

rossum - 12 Dec 2005 22:01 GMT

>Hi,
>
[quoted text clipped - 15 lines]
>
>How can I do it using a DataSet?

Have you tried:

<?xml version = "1.0"?>
<root>
<class>
<student>
<studentID>13429</studentID>
<studentName>John</studentName>
</student>
<student>
<studentID>13430</studentID>
<studentName>Mary</studentName>
</student>
</class>
</root>

rossum

The ultimate truth is that there is no ultimate truth

Reply to this Message

xml and data sets

Free Magazines