怎么把SQL的VIEW转换成XML Schema
<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='id' rs:number='1' rs:writeunknown='true'>
<s:datatype dt:type='int' dt:maxLength='4' rs:precision='10' rs:fixedlength='true' rs:maybenull='false'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row />
</rs:data>
</xml>
我要的是这种格式(准确说是VIEW的结构,数据暂时不要)
急救!!!! --------------------编程问答--------------------
ds.WriteXmlSchema(路径); --------------------编程问答--------------------
ds.WriteXmlSchema(@"c:\Kevin.xml");
得到结果
<?xml version="1.0" standalone="yes" ?>
- <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" msdata:Locale="zh-CN">
- <xs:complexType>
- <xs:choice maxOccurs="unbounded">
- <xs:element name="Table">
- <xs:complexType>
- <xs:sequence>
<xs:element name="functionname" type="xs:string" minOccurs="0" />
<xs:element name="modulename" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
补充:.NET技术 , C#