XML的内容:
<ITEMS>
<ITEM OPERATION="ADD">
<PARTNUMBER>IFR28469/603</PARTNUMBER>
<MANUFACTURER>AMIS</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>33</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER></PARTNUMBER>
<MANUFACTURER>ALLEGRO</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>型号错误</DESCRIPTION>
<QUANTITY>35</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>CRN-6INCHES-01</PARTNUMBER>
<MANUFACTURER>ST</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>38</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>UD61256DC</PARTNUMBER>
<MANUFACTURER>ZMD</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>40</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>X25128S</PARTNUMBER>
<MANUFACTURER>XICOR</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>44</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>250-5700-149TCU</PARTNUMBER>
<MANUFACTURER>AMIS</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>47</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>TA01D</PARTNUMBER>
<MANUFACTURER>ST</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>50</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>BTS734L1</PARTNUMBER>
<MANUFACTURER>Infineon</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>54</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>TSS463</PARTNUMBER>
<MANUFACTURER>ATMEL</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>57</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>ISL3684AIRZ</PARTNUMBER>
<MANUFACTURER>INTERSIL</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>60</QUANTITY>
</ITEM>
</ITEM>如何将这样的一个XML的数据上传上去,数据库是SQL SERVER 2000
<ITEMS>
<ITEM OPERATION="ADD">
<PARTNUMBER>IFR28469/603</PARTNUMBER>
<MANUFACTURER>AMIS</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>33</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER></PARTNUMBER>
<MANUFACTURER>ALLEGRO</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>型号错误</DESCRIPTION>
<QUANTITY>35</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>CRN-6INCHES-01</PARTNUMBER>
<MANUFACTURER>ST</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>38</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>UD61256DC</PARTNUMBER>
<MANUFACTURER>ZMD</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>40</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>X25128S</PARTNUMBER>
<MANUFACTURER>XICOR</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>44</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>250-5700-149TCU</PARTNUMBER>
<MANUFACTURER>AMIS</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>47</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>TA01D</PARTNUMBER>
<MANUFACTURER>ST</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>50</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>BTS734L1</PARTNUMBER>
<MANUFACTURER>Infineon</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>54</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>TSS463</PARTNUMBER>
<MANUFACTURER>ATMEL</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>57</QUANTITY>
</ITEM>
<ITEM OPERATION="ADD">
<PARTNUMBER>ISL3684AIRZ</PARTNUMBER>
<MANUFACTURER>INTERSIL</MANUFACTURER>
<MODELNUMBER>2005+</MODELNUMBER>
<DESCRIPTION>If you have some inquiry, Pls call us or Msn: [email protected]</DESCRIPTION>
<QUANTITY>60</QUANTITY>
</ITEM>
</ITEM>如何将这样的一个XML的数据上传上去,数据库是SQL SERVER 2000
http://blog.csdn.net/online/archive/2004/07/07/35994.aspx
問題是能否把.NET中的一些技術應用到6.0中來呢?
這個問題值得研究研究
解析xml然后对数据库进行操作
在工程用引用一个xml4.0
把xml转换为xml文档格式
dim xmlDoc as new MSXML2.DOMDocument40
xmlDoc.loadxml="你的xml内容"
然后逐行读取内容
If xmlDoc.childNodes(0).hasChildNodes Then
For i = 0 To xmlDoc.childNodes(0).childNodes.Length - 1
'逐行解析并存入数据库
next
end if