怎么把SQL的VIEW转换成XML Schema

问题描述

<xmlxmlns: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:Schemaid='RowsetSchema'><s:ElementTypename='row'content='eltOnly'><s:AttributeTypename='id'rs:number='1'rs:writeunknown='true'><s:datatypedt: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");得到结果<?xmlversion="1.0"standalone="yes"?>-<xs:schemaid="NewDataSet"xmlns=""xmlns:xs="http://www.w3.org/2001/XMLSchema"xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">-<xs:elementname="NewDataSet"msdata:IsDataSet="true"msdata:Locale="zh-CN">-<xs:complexType>-<xs:choicemaxOccurs="unbounded">-<xs:elementname="Table">-<xs:complexType>-<xs:sequence><xs:elementname="functionname"type="xs:string"minOccurs="0"/><xs:elementname="modulename"type="xs:string"minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:choice></xs:complexType></xs:element></xs:schema>