Filling a DataSet from a sql query against a XML schema

Hi

I'd like to know if it's possible, with an OleDbProvider, to fill a
dataset from a sql squery against a XML schema.

For exemple, i have this OleDbCommand :
SELECT computer.name, processor.frequency, soundCard.model
FROM computer
INNER JOIN processor ON computer.processor_id = processor.id
LEFT OUTER JOIN soundCard ON computer.soundCard_id = SoundCard.id

After I use an OleDbDataAdapter to fill a dataset whose name is
"computers".
And I want to have to get the Xml data of this dataset.

The result i want (by getting Xml) is
<computers>
<computer>
<name>My Computer</name>
<processor>
<frequency>3Hz</frequency>
</processor>
<soundCard>
<model>16 Bits sound card</model>
</soundCard>
</computer>
</computers>

But I have :
<computers>
<computer>
<name>My Computer</name>
<frequency>3Hz</frequency>
<model>16 Bits sound card</model>
</computer>
</computers>

I tried to load a schema into the dataset with ReadXml method but it
seems that it doesn't work after the oleDbDataAdapter Fill method.

I tried Microsoft SQLXML but it's still incomplete and very slow.

So If someone knows if the thing i want to do is possible, please
answer.

Thanks

Monorom SARIN

One
Wed Sep 17 04:20:41 CDT 2003

I dont think this is possible, but you can import the XML into a dataset and
then define your dataview to include particular records.



"Monorom" <monorom@wanadoo.fr> wrote in message
news:28fc0406.0309161354.13bf15bc@posting.google.com...
> Hi
>
> I'd like to know if it's possible, with an OleDbProvider, to fill a
> dataset from a sql squery against a XML schema.
>
> For exemple, i have this OleDbCommand :
> SELECT computer.name, processor.frequency, soundCard.model
> FROM computer
> INNER JOIN processor ON computer.processor_id = processor.id
> LEFT OUTER JOIN soundCard ON computer.soundCard_id = SoundCard.id
>
> After I use an OleDbDataAdapter to fill a dataset whose name is
> "computers".
> And I want to have to get the Xml data of this dataset.
>
> The result i want (by getting Xml) is
> <computers>
> <computer>
> <name>My Computer</name>
> <processor>
> <frequency>3Hz</frequency>
> </processor>
> <soundCard>
> <model>16 Bits sound card</model>
> </soundCard>
> </computer>
> </computers>
>
> But I have :
> <computers>
> <computer>
> <name>My Computer</name>
> <frequency>3Hz</frequency>
> <model>16 Bits sound card</model>
> </computer>
> </computers>
>
> I tried to load a schema into the dataset with ReadXml method but it
> seems that it doesn't work after the oleDbDataAdapter Fill method.
>
> I tried Microsoft SQLXML but it's still incomplete and very slow.
>
> So If someone knows if the thing i want to do is possible, please
> answer.
>
> Thanks
>
> Monorom SARIN