当前位置:编程学习 > C#/ASP.NET >>

怎么把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#
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,