<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:gxsbdConnectionString %>"
SelectCommand="SELECT JJGL_JJFB_DATA_1.* FROM JJFB_DATA AS JJGL_JJFB_DATA_1 WHERE (@查询名称 LIKE '%' + @查询关键字 + '%')"> <SelectParameters>
<asp:ControlParameter ControlID="searchname" DefaultValue="型号规格" Name="查询名称"
PropertyName="Text" />
<asp:ControlParameter ControlID="searchkeys" DefaultValue="%" Name="查询关键字"
PropertyName="Text" />
</SelectParameters> </asp:SqlDataSource>**********
WHERE (@查询名称
*********如何写才正确,谢了
ConnectionString="<%$ ConnectionStrings:gxsbdConnectionString %>"
SelectCommand="SELECT JJGL_JJFB_DATA_1.* FROM JJFB_DATA AS JJGL_JJFB_DATA_1 WHERE (@查询名称 LIKE '%' + @查询关键字 + '%')"> <SelectParameters>
<asp:ControlParameter ControlID="searchname" DefaultValue="型号规格" Name="查询名称"
PropertyName="Text" />
<asp:ControlParameter ControlID="searchkeys" DefaultValue="%" Name="查询关键字"
PropertyName="Text" />
</SelectParameters> </asp:SqlDataSource>**********
WHERE (@查询名称
*********如何写才正确,谢了
SelectCommand="exec('SELECT JJGL_JJFB_DATA_1.* FROM JJFB_DATA AS JJGL_JJFB_DATA_1 WHERE ['+@查询名称+'] LIKE '%'+@查询关键字+'%'')">
它提示:
异常详细信息: System.Data.SqlClient.SqlException: '%' 附近有语法错误。