In asp.net (C #), multiple dropdownlists and TextBox multi-condition queries are implemented,
Multi-condition query is implemented through statement concatenation.
Main Code:
<% @ Page Language = "C #" AutoEventWireup = "true" CodeFile = "Default19.aspx. cs" Inherits = "Default19" %> <! DOCTYPE html PUBLIC "-// W3C // dtd xhtml 1.0 Transitional // EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
protected void btn_search_Click(object sender, EventArgs e) { string strfacy = "select * from tOrderReview where 1=1"; if (!string.IsNullOrEmpty(tb_x1.Text.ToString())) { strfacy += " and " + DropDownList1.SelectedValue.ToString() + " like '%" + tb_x1.Text.ToString() + "%'"; } if (!string.IsNullOrEmpty(tb_x2.Text.ToString())) { strfacy += " and " + DropDownList2.SelectedValue.ToString() + " like '%" + tb_x2.Text.ToString() + "%'"; } if (!string.IsNullOrEmpty(tb_x3.Text.ToString())) { strfacy += " and " + DropDownList3.SelectedValue.ToString() + " like '%" + tb_x3.Text.ToString() + "%'"; } strfacy += " order by OrderID desc"; //GridBind(strfacy); }
The general situation is like this. It's quite easy to use. It's much easier than the method I used before.