先给大家看一下效果 :
首先要准备两个数据源,一个是主表数据源,一个是从表数据源。
- 主表数据源
<
asp:AccessDataSource ID
=
"
AccessDataSource_Master
"
runat
=
"
server
"
DataFile
=
"
~/App_Data/Master-Detail.mdb
"
SelectCommand = " SELECT * FROM [订单] " DeleteCommand = " DELETE FROM [订单] WHERE [订单 ID] = ? " InsertCommand = " INSERT INTO [订单] ([订单 ID], [订购日期], [采购订单编号], [要求截止日期],
SelectCommand = " SELECT * FROM [订单] " DeleteCommand = " DELETE FROM [订单] WHERE [订单 ID] = ? " InsertCommand = " INSERT INTO [订单] ([订单 ID], [订购日期], [采购订单编号], [要求截止日期],