on a form i have placed
1. Combobox(for Column Name)
2. Combobox for Searching Criterai (e.g like, =, not equal, In, <, >)
3. Text box (specific word or phrase searching)
4. Combobox For and or OR Operator
5. Button: with event which will generate above 1,2,3,4 once again
Now i want to make a searching form using above thing. I want to make General Query for all.
User can
(1)user select any column name
then (2) select his searching criterai
then (2) type the phrase or word
then (3) Select the operator
if user want more then click the button and add more 1,2,3,4 group of control again and again fill by his requirements.