xml与Access数据库的转换案例

<?xml version="1.0" standalone="yes"?> <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" msdata:MainDataTable="Code" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Code"> <xs:complexType> <xs:sequence> <xs:element name="CID" type="xs:int" minOccurs="0" /> <xs:element name="Describe" type="xs:string" minOccurs="0" /> <xs:element name="SendCode" type="xs:string" minOccurs="0" /> <xs:element name="ReturnCodeR" type="xs:string" minOccurs="0" /> <xs:element name="ReturnCodeE" type="xs:string" minOccurs="0" /> <xs:element name="xhid" type="xs:int" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema> <Code> <CID>1</CID> <Describe>端口1开</Describe> <SendCode>CA 20 F0 18 02 01 01 AC</SendCode> <xhid>3</xhid> </Code> <Code> <CID>2</CID> <Describe>端口1关</Describe> <SendCode>CA 20 F0 18 02 01 00 AC</SendCode> <xhid>3</xhid> </Code> <Code> <CID>3</CID> <Describe>端口2开</Describe> <SendCode>CA 20 F0 18 02 02 01 AC</SendCode> <ReturnCodeR /> <ReturnCodeE /> <xhid>3</xhid> </Code> <Code> <CID>4</CID> <Describe>端口2关</Describe> <SendCode>CA 20 F0 18 02 02 00 AC</SendCode> <ReturnCodeR>11</ReturnCodeR> <ReturnCodeE>1</ReturnCodeE> <xhid>4</xhid> </Code> <Code> <CID>6</CID> <Describe>端口3关</Describe> <SendCode>CA 20 F0 18 02 03 00 AC</SendCode> <ReturnCodeR>0</ReturnCodeR> <ReturnCodeE>2</ReturnCodeE> <xhid>4</xhid> </Code> <Code> <CID>9</CID> <Describe>菜植渠</Describe> <SendCode>CA 20 F0 18 02 04 00 AC</SendCode> <ReturnCodeR>001</ReturnCodeR> <ReturnCodeE>110</ReturnCodeE> <xhid>4</xhid> </Code> <Code> <CID>10</CID> <Describe>菜小明2号</Describe> <SendCode>sbsbsbsb</SendCode> <ReturnCodeR>001</ReturnCodeR> <ReturnCodeE>011</ReturnCodeE> <xhid>11</xhid> </Code> <Code> <CID>23</CID> <Describe>001</Describe> <SendCode>abc</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>11</xhid> </Code> <Code> <CID>24</CID> <Describe>002</Describe> <SendCode>bcd</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>11</xhid> </Code> <Code> <CID>25</CID> <Describe>003</Describe> <SendCode>cde</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>11</xhid> </Code> <Code> <CID>26</CID> <Describe>004</Describe> <SendCode>def</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>11</xhid> </Code> <Code> <CID>27</CID> <Describe>005</Describe> <SendCode>efg</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>11</xhid> </Code> <Code> <CID>28</CID> <Describe>001</Describe> <SendCode>abc</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>10</xhid> </Code> <Code> <CID>30</CID> <Describe>003</Describe> <SendCode>cde</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>10</xhid> </Code> <Code> <CID>31</CID> <Describe>004</Describe> <SendCode>def</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>10</xhid> </Code> <Code> <CID>48</CID> <Describe>001</Describe> <SendCode>abc</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>4</xhid> </Code> <Code> <CID>49</CID> <Describe>002</Describe> <SendCode>bcd</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>4</xhid> </Code> <Code> <CID>50</CID> <Describe>003</Describe> <SendCode>cde</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>4</xhid> </Code> <Code> <CID>51</CID> <Describe>004</Describe> <SendCode>def</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>4</xhid> </Code> <Code> <CID>53</CID> <Describe>001</Describe> <SendCode>abc</SendCode> <ReturnCodeR>ddd</ReturnCodeR> <ReturnCodeE>ddd000</ReturnCodeE> <xhid>3</xhid> </Code> <Code> <CID>55</CID> <Describe>003</Describe> <SendCode>cde</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>3</xhid> </Code> <Code> <CID>56</CID> <Describe>004</Describe> <SendCode>def</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>3</xhid> </Code> <Code> <CID>57</CID> <Describe>005</Describe> <SendCode>efg</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>3</xhid> </Code> <Code> <CID>73</CID> <Describe>001</Describe> <SendCode>abc</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>10</xhid> </Code> <Code> <CID>78</CID> <Describe>001</Describe> <SendCode>abc</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>3</xhid> </Code> <Code> <CID>79</CID> <Describe>002</Describe> <SendCode>bcd</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>3</xhid> </Code> <Code> <CID>80</CID> <Describe>003</Describe> <SendCode>cde</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>3</xhid> </Code> <Code> <CID>81</CID> <Describe>004</Describe> <SendCode>def</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>3</xhid> </Code> <Code> <CID>82</CID> <Describe>005</Describe> <SendCode>efg</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>3</xhid> </Code> <Code> <CID>89</CID> <Describe>大水牛2号指令</Describe> <SendCode>welcome</SendCode> <ReturnCodeR /> <ReturnCodeE /> <xhid>44</xhid> </Code> <Code> <CID>90</CID> <Describe>001</Describe> <SendCode>abc</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>44</xhid> </Code> <Code> <CID>91</CID> <Describe>002</Describe> <SendCode>bcd</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>44</xhid> </Code> <Code> <CID>92</CID> <Describe>003</Describe> <SendCode>cde</SendCode> <ReturnCodeR>a</ReturnCodeR> <ReturnCodeE>a</ReturnCodeE> <xhid>44</xhid> </Code> <Code> <CID>93</CID> <Describe>004</Describe> <SendCode>def</SendCode> <ReturnCodeR>d</ReturnCodeR> <ReturnCodeE>d</ReturnCodeE> <xhid>44</xhid> </Code> <Code> <CID>104</CID> <Describe>11111111111111</Describe> <SendCode>000</SendCode> <ReturnCodeR /> <ReturnCodeE /> <xhid>47</xhid> </Code> <Code> <CID>105</CID> <Describe>菜植渠</Describe> <SendCode>CA 20 F0 18 02 04 00 AC</SendCode> <ReturnCodeR>001</ReturnCodeR> <ReturnCodeE>110</ReturnCodeE> <xhid>3</xhid> </Code> <Code> <CID>106</CID> <Describe>端口1开</Describe