在bcb和Delphi中可以直接用ado控件把数据集转换为一种xml格式,
<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' rs:updatable='true'>
<s:AttributeType name='id' rs:number='1' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='ceshi' rs:basetable='test'
rs:basecolumn='id'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='10' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='name' rs:number='2' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='ceshi'
rs:basetable='test' rs:basecolumn='name'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='10' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='descrip' rs:number='3' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='ceshi'
rs:basetable='test' rs:basecolumn='descrip'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='10' rs:fixedlength='true'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row id='12 ' name='122 ' descrip='122 '/>
<z:row id='21 ' name='234 ' descrip='456 '/>
<z:row id='34324 ' name='54 ' descrip='788 '/>
</rs:data>
</xml>
跪求各位大大,asp.net有什么方法能直接这样生成吗
<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' rs:updatable='true'>
<s:AttributeType name='id' rs:number='1' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='ceshi' rs:basetable='test'
rs:basecolumn='id'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='10' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='name' rs:number='2' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='ceshi'
rs:basetable='test' rs:basecolumn='name'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='10' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='descrip' rs:number='3' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='ceshi'
rs:basetable='test' rs:basecolumn='descrip'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='10' rs:fixedlength='true'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row id='12 ' name='122 ' descrip='122 '/>
<z:row id='21 ' name='234 ' descrip='456 '/>
<z:row id='34324 ' name='54 ' descrip='788 '/>
</rs:data>
</xml>
跪求各位大大,asp.net有什么方法能直接这样生成吗
{
DataSet ds = dt;
StringBuilder sb = new StringBuilder();
sb.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?> ");
sb.Append("<authors>");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
sb.Append("<author>");
DataRow dr = ds.Tables[0].Rows[i];
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
string colname = ds.Tables[0].Columns[j].ColumnName; sb.AppendFormat("<{0}>{1}</{2}>", colname, dr[colname].ToString(), colname);
} sb.Append("</author>");
}
sb.Append("</authors>");
return sb;
}
使用XmlConvert类参考:C#中将DataSet的内容写成XML
string xml1 = ds.GetXml();
string xml2 = ds.GetXmlSchema();