一 自己定义查询语句;
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>