×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

请问有没有哪为兄弟知道how to using ASP script to input a XML file into a SQL server table????xml code is inside..

<?xml version="1.0" encoding="en-US" standalone="yes"?>
<!-- Generated by Softsilver Transformer 2.3 *** UNREGISTERED *** (http://www.softsilver.com) -->
<document>
<row>
<SOURCE>40532</SOURCE>
<CLIENT>EAST</CLIENT>
<RECEIPT__NUMBER>14585</RECEIPT__NUMBER>
<UNITS>60</UNITS>
<SMAL>0</SMAL>
<AVER>0</AVER>
<LARG>0</LARG>
<RVPK>1</RVPK>
<PALL>0</PALL>
</row>
<row>
<SOURCE>40532</SOURCE>
<CLIENT>EAST</CLIENT>
<RECEIPT__NUMBER>14585</RECEIPT__NUMBER>
<UNITS>60</UNITS>
<SMAL>0</SMAL>
<AVER>0</AVER>
<LARG>0</LARG>
<RVPK>1</RVPK>
<PALL>0</PALL>
</row>
</document>
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / 请问有没有哪为兄弟知道how to using ASP script to input a XML file into a SQL server table????xml code is inside..
    <?xml version="1.0" encoding="en-US" standalone="yes"?>
    <!-- Generated by Softsilver Transformer 2.3 *** UNREGISTERED *** (http://www.softsilver.com) -->
    <document>
    <row>
    <SOURCE>40532</SOURCE>
    <CLIENT>EAST</CLIENT>
    <RECEIPT__NUMBER>14585</RECEIPT__NUMBER>
    <UNITS>60</UNITS>
    <SMAL>0</SMAL>
    <AVER>0</AVER>
    <LARG>0</LARG>
    <RVPK>1</RVPK>
    <PALL>0</PALL>
    </row>
    <row>
    <SOURCE>40532</SOURCE>
    <CLIENT>EAST</CLIENT>
    <RECEIPT__NUMBER>14585</RECEIPT__NUMBER>
    <UNITS>60</UNITS>
    <SMAL>0</SMAL>
    <AVER>0</AVER>
    <LARG>0</LARG>
    <RVPK>1</RVPK>
    <PALL>0</PALL>
    </row>
    </document>
    • up.up... :(
    • it's easy,
      use asp to create two server objects, first one is for accessing xml date from xml file(server.createobject("microsoft.xmldom")), another one is for accessing database(server.createobject("adodb.connection")), then use xml API to get data from xml file and store it into table.