Filling a DataSet from a sql query against a XML schema

  • Thread starter Thread starter Monorom
  • Start date Start date
M

Monorom

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
 
I dont think this is possible, but you can import the XML into a dataset and
then define your dataview to include particular records.
 
Back
Top