I need help in writing a datatable as xml in an aspx page. I have an
excel client that opens the response as a stream into a recordset. In
converting this code to .net c# from asp vb (where is used an
adodb.stream, I can't seem to get the output right. I've tried the a
gazillion methods, using memorystream, xmltextwriter, xmldatadoc, etc.
all returning invalid xml (see below). What i need is xml that looks
like the code at the end of this post - thanks for your help!
<!-- for example - this: //-->
StringWriter sw = new StringWriter();
dt.DataSet.WriteXml(sw,XmlWriteMode.WriteSchema);
string s = sw.ToString();
Response.Write("<?xml version='1.0' ?>");
Response.Write(s);
<!-- returns this: //-->
<?xml version="1.0" ?>
- <NewDataSet>
- <xs:schema id="NewDataSet" xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
- <xs:element name="NewDataSet" msdata:IsDataSet="true">
- <xs:complexType>
- <xs:choice maxOccurs="unbounded">
- <xs:element name="Table">
- <xs:complexType>
- <xs:sequence>
<xs:element name="VAR_VALUE" type="xs:string" minOccurs="0" />
<xs:element name="VAR_KEY" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
- <Table>
<VAR_VALUE>LSUS</VAR_VALUE>
<VAR_KEY>DIVISION</VAR_KEY>
</Table>
- <Table>
<VAR_VALUE>DB2T</VAR_VALUE>
<VAR_KEY>x</VAR_KEY>
</Table>
- <Table>
<VAR_VALUE>TRUE</VAR_VALUE>
<VAR_KEY>Y</VAR_KEY>
</Table>
</NewDataSet>
<!-- I need this: //-->
<?xml version='1.0' ?>
<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly'>
<s:AttributeType name='VAR_VALUE' rs:number='1'
s:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='200'/>
</s:AttributeType>
<s:AttributeType name='VAR_KEY' rs:number='2'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='10'
rs:maybenull='false'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row VAR_VALUE='LSUS' VAR_KEY='DIVISION'/>
<z:row VAR_VALUE='DB2P' VAR_KEY='DB2DSN'/>
<z:row VAR_VALUE='TRUE' VAR_KEY='PRODPROF'/>
</rs:data>
</xml>
