Getting XML out of Dataset

[Guest]

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.aspx?scid=kb;EN-US;311937

 

[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!
************************************************

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.

 

[Mark Miller]

Those are the only two methods that I have seen.

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

 

[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

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.