<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/mdb/jiuzhou.mdb"
SelectCommand="SELECT * FROM [book] WHERE ([bookname] LIKE '%' + ? + '%') ORDER BY [bookID]" CacheKeyDependency="ADS_Orders" EnableCaching="True" OnSelected="AccessDataSource1_Selected">
<SelectParameters>
<asp:Parameter DefaultValue="罗" Name="bookname" Type="String" />
</SelectParameters>
</asp:AccessDataSource>在SelectCommand="SELECT * FROM [book] WHERE ([bookname] LIKE '%' + ? + '%') ORDER BY [bookID]" 中bookname也是变量应该如何写代码?
我是要实现根据条件判断对book表中的相应字段进行LIKE查询.
SelectCommand="SELECT * FROM [book] WHERE ([bookname] LIKE '%' + ? + '%') ORDER BY [bookID]" CacheKeyDependency="ADS_Orders" EnableCaching="True" OnSelected="AccessDataSource1_Selected">
<SelectParameters>
<asp:Parameter DefaultValue="罗" Name="bookname" Type="String" />
</SelectParameters>
</asp:AccessDataSource>在SelectCommand="SELECT * FROM [book] WHERE ([bookname] LIKE '%' + ? + '%') ORDER BY [bookID]" 中bookname也是变量应该如何写代码?
我是要实现根据条件判断对book表中的相应字段进行LIKE查询.
例如在Page_Load事件中
AccessDataSource1.SelectParameters["bookname"].DefaultValue = "%中国%";
就可以替换select语句中的条件