Dataset.WriteXML attributes instead of elements?

[Michel Müller]

I am re-writing a vb script that queries an SQL server and then uses the
recordset to generate an xml file. The xml file has a row-set schema with
row as the element and the columns as attributes: <z:row ID="1"
CapConDerivedName="AV_TOUCH_SCREEN_SOUND_LEVEL_ENABLED"
DataStructureType="bool" EnumType="None" Unit="none" SetValue="0" DSTID="2"
/>


I am using C# and dataSet.WriteXml(fileName, XmlWriteMode.WriteSchema);
The problem I am having is that WriteXml structures the column data as
elements instead of attributes.



Thanks for infos

Michel