Multi-criteria search questions !!!

牧野鹰扬

There are multiple dropdownlists on the page, the contents of which are linked menus of regions, provinces, and cities, and a textbox for entering keywords. A search button ...

Each dropdownlist has all of this option.The purpose I want to achieve is to display the corresponding items from the database based on so many conditions + keywords. Of course, if not selected in the dropdownlist, it is equivalent to selecting all

How to write a statement in such a search situation ???

Help me !!!

shenmue024

string strSQL = "Select * from table where 1 = 1";

if (dropdownlist1.SelectedValue.Trim ()! = "")
{
   strSQL + = "and field 1 = '" + dropdownlist1.SelectedValue + "'";
}

if (dropdownlist2.SelectedValue.Trim ()! = "")
{
   strSQL + = "and field 2 = '" + dropdownlist2.SelectedValue + "'";
}

寒雪鸣

string temp = "";
if (dropdownlist1.selectedvalue.tostring (). Equals ("all"))
temp = "1 = 1 and";
else
temp = "field name = '" + dropdownlist1.selectedvalue + "' and";
if (dropdownlist2.selectedvalue.tostring (). Equals ("all"))
temp = temp + "1 = 1 and";
else
temp = "field name = '" + dropdownlist2.selectedvalue + "' and";
...............
The last one removes and

牧野鹰扬

I searched on the homepage, and then displayed it on other pages. It was displayed using a repeater. I have to pass the value.

kobejjj

Set the value of DropDownList as a keyword

Then concatenate the strings

六零六

Address bar or session by value

It's better to use the address bar, and it's better to encrypt

六零六

Pass the conditions, and then read the data on the page you need to display

dellhuang

If the provinces, cities and counties are linked, only one parameter should be sufficient, because if it is Changsha, it must be Hunan Province.

Pass this parameter and query keywords directly in the form of QueryString and it will be OK

牧野鹰扬

Then if one of the pass values ​​is not selected, it will be wrong ...

牧野鹰扬

It seems wrong