Gridview 条件(模糊)查询语句

来源：互联网发布：淘宝店铺装修客服中心编辑：程序博客网时间：2024/06/05 02:31

一自己定义查询语句;

protected void Search_Click(object sender, ImageClickEventArgs e)
    {
        String str = TextBox1.Text.ToString();
        AccessDataSource1.SelectCommand = "SELECT * FROM [JwcDownload] Where D_ViewName like @str";
        AccessDataSource1.SelectParameters.Add("@str", "%" + str + "%");
        AccessDataSource1.DataBind();
        TextBox1.Text="";

    }
二:利用GridVIew的查询条件查询

主要代码:

SelectCommand="SELECT customer.cst_id, customer.cst_campany_name, customer.cst_type, customer.cst_area, customer.cst_man_name, customer.cst_man_phone, customer.cst_mdc_sum FROM customer INNER JOIN customer_conn ON customer.cst_id = customer_conn.cst_id WHERE (customer.cst_campany_name LIKE '%' + @tbx_campany_name + '%')">

<SelectParameters>
<asp:ControlParameter ControlID="tbx_campany_name" Name="tbx_campany_name" PropertyName="Text" Type="String" DefaultValue=" "/>

</SelectParameters>