前台是用GridView自动生成的查询语句
请问能动态改变 where 里的条件吗?谢谢! WHERE name like '%'+keyword+'%'这部分能改为用户输入的关键字 做为查询条件吗?<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:mapConnectionString %>"
SelectCommand="SELECT [id], [name], [class], [x4], [y4], [picurl], [address], [menpai], [phone], [email], [linkman], [wangzhi] FROM [object_point] WHERE name like '%酒店%' ORDER BY [id]"
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="class" Type="String" />
<asp:Parameter Name="x4" Type="Double" />
<asp:Parameter Name="y4" Type="Double" />
<asp:Parameter Name="picurl" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="menpai" Type="String" />
<asp:Parameter Name="phone" Type="String" />
<asp:Parameter Name="Email" Type="String" />
<asp:Parameter Name="linkman" Type="String" />
<asp:Parameter Name="wangzhi" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="class" Type="String" />
<asp:Parameter Name="x4" Type="Double" />
<asp:Parameter Name="y4" Type="Double" />
<asp:Parameter Name="picurl" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="menpai" Type="String" />
<asp:Parameter Name="phone" Type="String" />
<asp:Parameter Name="Email" Type="String" />
<asp:Parameter Name="linkman" Type="String" />
<asp:Parameter Name="wangzhi" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
请问能动态改变 where 里的条件吗?谢谢! WHERE name like '%'+keyword+'%'这部分能改为用户输入的关键字 做为查询条件吗?<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:mapConnectionString %>"
SelectCommand="SELECT [id], [name], [class], [x4], [y4], [picurl], [address], [menpai], [phone], [email], [linkman], [wangzhi] FROM [object_point] WHERE name like '%酒店%' ORDER BY [id]"
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="class" Type="String" />
<asp:Parameter Name="x4" Type="Double" />
<asp:Parameter Name="y4" Type="Double" />
<asp:Parameter Name="picurl" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="menpai" Type="String" />
<asp:Parameter Name="phone" Type="String" />
<asp:Parameter Name="Email" Type="String" />
<asp:Parameter Name="linkman" Type="String" />
<asp:Parameter Name="wangzhi" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="class" Type="String" />
<asp:Parameter Name="x4" Type="Double" />
<asp:Parameter Name="y4" Type="Double" />
<asp:Parameter Name="picurl" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="menpai" Type="String" />
<asp:Parameter Name="phone" Type="String" />
<asp:Parameter Name="Email" Type="String" />
<asp:Parameter Name="linkman" Type="String" />
<asp:Parameter Name="wangzhi" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
this.SqlDataSource1.SelectCommand = ".........";
}
<SelectParameters>
<asp:ControlParameter />
<asp:QueryStringParameter />
</SelectParameters>
</asp:SqlDataSource>
<asp:QueryStringParameter />注意这两行,能改变参数的类型,你可以试试.