XML数据岛主从表的建立

Use the Master/Detail Feature with the C++ XML Data Source Object
Create Noname1.XML
<orders>
  <order order_number="2233">
    <customer>
      <name>John Smith</name>
      <custID>192883</custID>
    </customer>
    <item>     
      <name>Fly Swatter</name>   
      <price>9.99</price>   
    </item> 
  </order>
  <order order_number="2234"> 
    <customer>  
      <name>Marea Angela Castaneda</name>     
      <custID>827145</custID> 
    </customer>   
    <item>   
      <name>Fly Paper</name>   
      <price>15.99</price>   
    </item> 
  </order> 
  <order order_number="2235">
    <customer>  
      <name>Amy Jones</name>     
      <custID>998022</custID>  
    </customer>  
    <item>     
      <name>Mosquito Netting</name>
      <price>38.99</price>   
    </item>
  </order>
</orders>

Create Html
<XML ID=xmlDoc src="Noname1.xml"></XML>

<P>ORDER NUMBER: <SPAN DATASRC="#xmlDoc" DATAFLD="order_number"></SPAN></P>
<TABLE DATASRC="#xmlDoc" DATAFLD="customer" BORDER>
  <THEAD><TH>NAME</TH><TH>ID</TH></THEAD>
  <TR>
    <TD><SPAN DATAFLD="name"></SPAN></TD>
    <TD><SPAN DATAFLD="custID"></SPAN></TD>
  </TR>
</TABLE>
<TABLE DATASRC="#xmlDoc" DATAFLD="item" BORDER=1>
  <THEAD><TR><TH>ITEM</TH><TH>PRICE</TH></TR></THEAD>
  <TR>
    <TD><SPAN DATAFLD="name"></SPAN></TD>
    <TD><SPAN DATAFLD="price"></SPAN></TD>
  </TR>
</TABLE>
<INPUT TYPE=BUTTON VALUE="Previous Order" οnclick="Previous()">
<INPUT TYPE=BUTTON VALUE="Next Order" οnclick="Next()">

<script LANGUAGE="JScript">
function Previous(){
 if (xmlDoc.recordset.AbsolutePosition > 1) 
 xmlDoc.recordset.movePrevious();
 else
 alert("Already at first record.");
}
function Next(){
 if (xmlDoc.recordset.AbsolutePosition < xmlDoc.recordset.RecordCount)
 xmlDoc.recordset.moveNext();
 else  alert("Already at last record.");
}
</script>

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值