Gridview 条件(模糊)查询语句

一 自己定义查询语句;

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>