代码如下:
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
ConflictDetection="CompareAllValues" DataFile="~/#lan_net#.lan"
DeleteCommand="DELETE FROM [ql_xuyuan] WHERE [cid] = ? AND (([cdate] = ?) OR ([cdate] IS NULL AND ? IS NULL)) AND (([xy_zuozhe] = ?) OR ([xy_zuozhe] IS NULL AND ? IS NULL)) AND (([xy_neirong] = ?) OR ([xy_neirong] IS NULL AND ? IS NULL)) AND (([xy_yanse] = ?) OR ([xy_yanse] IS NULL AND ? IS NULL)) AND (([ip] = ?) OR ([ip] IS NULL AND ? IS NULL))"
InsertCommand="INSERT INTO [ql_xuyuan] ([cid], [cdate], [xy_zuozhe], [xy_neirong], [xy_yanse], [ip]) VALUES (?, ?, ?, ?, ?, ?)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT * FROM [ql_xuyuan] ORDER BY [cid] DESC"
UpdateCommand="UPDATE [ql_xuyuan] SET [cdate] = ?, [xy_zuozhe] = ?, [xy_neirong] = ?, [xy_yanse] = ?, [ip] = ? WHERE [cid] = ? AND (([cdate] = ?) OR ([cdate] IS NULL AND ? IS NULL)) AND (([xy_zuozhe] = ?) OR ([xy_zuozhe] IS NULL AND ? IS NULL)) AND (([xy_neirong] = ?) OR ([xy_neirong] IS NULL AND ? IS NULL)) AND (([xy_yanse] = ?) OR ([xy_yanse] IS NULL AND ? IS NULL)) AND (([ip] = ?) OR ([ip] IS NULL AND ? IS NULL))">
<DeleteParameters>
<asp:Parameter Name="original_cid" Type="Int32" />
<asp:Parameter Name="original_cdate" Type="DateTime" />
<asp:Parameter Name="original_xy_zuozhe" Type="String" />
<asp:Parameter Name="original_xy_neirong" Type="String" />
<asp:Parameter Name="original_xy_yanse" Type="String" />
<asp:Parameter Name="original_ip" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="cdate" Type="DateTime" />
<asp:Parameter Name="xy_zuozhe" Type="String" />
<asp:Parameter Name="xy_neirong" Type="String" />
<asp:Parameter Name="xy_yanse" Type="String" />
<asp:Parameter Name="ip" Type="String" />
<asp:Parameter Name="original_cid" Type="Int32" />
<asp:Parameter Name="original_cdate" Type="DateTime" />
<asp:Parameter Name="original_xy_zuozhe" Type="String" />
<asp:Parameter Name="original_xy_neirong" Type="String" />
<asp:Parameter Name="original_xy_yanse" Type="String" />
<asp:Parameter Name="original_ip" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="cid" Type="Int32" />
<asp:Parameter Name="cdate" Type="DateTime" />
<asp:Parameter Name="xy_zuozhe" Type="String" />
<asp:Parameter Name="xy_neirong" Type="String" />
<asp:Parameter Name="xy_yanse" Type="String" />
<asp:Parameter Name="ip" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
数据库acc,后缀名改成.lan,以上代码显示页面都正常的,就是无法编辑和删除等操作,请高手指点,谢谢!真是纠结啊……
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
ConflictDetection="CompareAllValues" DataFile="~/#lan_net#.lan"
DeleteCommand="DELETE FROM [ql_xuyuan] WHERE [cid] = ? AND (([cdate] = ?) OR ([cdate] IS NULL AND ? IS NULL)) AND (([xy_zuozhe] = ?) OR ([xy_zuozhe] IS NULL AND ? IS NULL)) AND (([xy_neirong] = ?) OR ([xy_neirong] IS NULL AND ? IS NULL)) AND (([xy_yanse] = ?) OR ([xy_yanse] IS NULL AND ? IS NULL)) AND (([ip] = ?) OR ([ip] IS NULL AND ? IS NULL))"
InsertCommand="INSERT INTO [ql_xuyuan] ([cid], [cdate], [xy_zuozhe], [xy_neirong], [xy_yanse], [ip]) VALUES (?, ?, ?, ?, ?, ?)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT * FROM [ql_xuyuan] ORDER BY [cid] DESC"
UpdateCommand="UPDATE [ql_xuyuan] SET [cdate] = ?, [xy_zuozhe] = ?, [xy_neirong] = ?, [xy_yanse] = ?, [ip] = ? WHERE [cid] = ? AND (([cdate] = ?) OR ([cdate] IS NULL AND ? IS NULL)) AND (([xy_zuozhe] = ?) OR ([xy_zuozhe] IS NULL AND ? IS NULL)) AND (([xy_neirong] = ?) OR ([xy_neirong] IS NULL AND ? IS NULL)) AND (([xy_yanse] = ?) OR ([xy_yanse] IS NULL AND ? IS NULL)) AND (([ip] = ?) OR ([ip] IS NULL AND ? IS NULL))">
<DeleteParameters>
<asp:Parameter Name="original_cid" Type="Int32" />
<asp:Parameter Name="original_cdate" Type="DateTime" />
<asp:Parameter Name="original_xy_zuozhe" Type="String" />
<asp:Parameter Name="original_xy_neirong" Type="String" />
<asp:Parameter Name="original_xy_yanse" Type="String" />
<asp:Parameter Name="original_ip" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="cdate" Type="DateTime" />
<asp:Parameter Name="xy_zuozhe" Type="String" />
<asp:Parameter Name="xy_neirong" Type="String" />
<asp:Parameter Name="xy_yanse" Type="String" />
<asp:Parameter Name="ip" Type="String" />
<asp:Parameter Name="original_cid" Type="Int32" />
<asp:Parameter Name="original_cdate" Type="DateTime" />
<asp:Parameter Name="original_xy_zuozhe" Type="String" />
<asp:Parameter Name="original_xy_neirong" Type="String" />
<asp:Parameter Name="original_xy_yanse" Type="String" />
<asp:Parameter Name="original_ip" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="cid" Type="Int32" />
<asp:Parameter Name="cdate" Type="DateTime" />
<asp:Parameter Name="xy_zuozhe" Type="String" />
<asp:Parameter Name="xy_neirong" Type="String" />
<asp:Parameter Name="xy_yanse" Type="String" />
<asp:Parameter Name="ip" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
数据库acc,后缀名改成.lan,以上代码显示页面都正常的,就是无法编辑和删除等操作,请高手指点,谢谢!真是纠结啊……
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货