<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 (@查询名称
********* 如何写才正确,谢了
如:
string f_Name=动态字段;
cmdText="SELECT JJGL_JJFB_DATA_1.* FROM JJFB_DATA AS JJGL_JJFB_DATA_1 WHERE ("+f_Name+" LIKE '%' + @查询关键字 + '%')";
string strKey="查询字符串";
SelectCommand="SELECT JJGL_JJFB_DATA_1.* FROM JJFB_DATA AS JJGL_JJFB_DATA_1 WHERE ('"+ strField +"' LIKE '%" + strKey +"%')";
查询字符串最好要用参数