两个DropdownList选定范围的数据库查询怎么做?
有一个多条件查询表单
其中有一个搜索项color,使用两个DropdownList 其中的项目都是("d","e","f","g","h","i","j","k“,"m","n","o-p","w-x","z","fancy")
选择这两个DropdownList以划定范围,比如:DropdownList1选择"e",DropdownList2选择"g",就是查询数据库中color字段匹配("e","f","g")的条目
请问大家这样的查询如何实现?如能解决,高分伺候!