Getting XML out of Dataset

[Richard]

Hi

Is it possible to define exactly what format the XML takes when you create it from a Dataset. I have defined a XML schema but the XML I get from the Dataset (which is a strongly typed dataset using my XML schema) doesn't use this schema ie I get the standard element type xml document.

Regards

Richard

[Mark Miller]

It sounds like you would like to output attributes instead of elements. If
this is the case then use the DataColumn.ColumnMapping property:

http://support.microsoft.com/default...b;EN-US;311937

[Mark Miller]

Those are the only two methods that I have seen.
"Richard" <rp**@newsgroups.nospan> wrote in message
news:6A**********************************@microsof t.com...

Ok

So I am correct in thinking that the only way to change the output style of XML from a dataset is to use the DataColumn.ColumnMapping property? And
if you want to change the style any further you will need to use XSL
Regards

[Cowboy]

Use a Transformation and an XSLT file against the XML from WriteXML. You can
then adjust the XML to any schema you desire. As far as automatically doing
it, there is no capability built in to .NET or VS.NET.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"Richard" <rp**@newsgroups.nospam> wrote in message
news:AD**********************************@microsof t.com...

Hi

Is it possible to define exactly what format the XML takes when you create it from a Dataset. I have defined a XML schema but the XML I get from the
Dataset (which is a strongly typed dataset using my XML schema) doesn't use
this schema ie I get the standard element type xml document.
Regards

Richard

[Daniel Cazzulino [MVP XML]]

Maybe if you try "wrapping" the dataset in an XmlDataDocument you get
something closer to what you need...

--
Daniel Cazzulino [MVP XML]
Clarius Consulting SA
http://weblogs.asp.net/cazzu
http://aspnet2.com

"Richard" <rp**@newsgroups.nospam> wrote in message
news:AD**********************************@microsof t.com...

Hi

Is it possible to define exactly what format the XML takes when you create it from a Dataset. I have defined a XML schema but the XML I get from the
Dataset (which is a strongly typed dataset using my XML schema) doesn't use
this schema ie I get the standard element type xml document.
Regards

Richard

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 23/05/2004