how to format the data in a dataset

[Kermit]

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"
CapConDerivedNa me="AV_TOUCH_SC REEN_SOUND_LEVE L_ENABLED"
DataStructureTy pe="bool" EnumType="None" Unit="none" SetValue="0" DSTID="2"
/>

I am using C# and dataSet.WriteXm l(fileName, XmlWriteMode.Wr iteSchema);
The problem I am having is that WriteXml structures the column data as
elements instead of attributes.
<Table>
<ID>1</ID>
<CapConDerivedN ame>AV_TOUCH_SC REEN_SOUND_LEVE L_ENABLED</CapConDerivedNa me>
<DataStructureT ype>bool</DataStructureTy pe>
<EnumType>Non e</EnumType>
<Unit>none</Unit>
<SetValue>0</SetValue>
<DSTID>2</DSTID>
</Table>

I need the file to have the same structure as the one produced by the vb
script. How can I define the dataset columns to be attributes instead of
elements?