Advanced Search form

Dealy

Hello,

I need help with "Advanced Search". I've seen other applications having a form that user can build queries from comboboxes choosing its own criteria and show them as reports.
For example in the first combobox they choose Table, then field,then criteria.

Is there any examples or explanation of how these works?

Thank you in advance.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jisss shyam17y ago
Accepted answer
hi,
you can create sql statements like this
string sql = "SELECT * FROM " + comoTable.Text + " WHERE " + comboField.Text + " " + comboCriteria.Text + " " + comboCritParam.Text + "";
you can change statement according to comboboxes and other controls
thanks
theLizard17y ago
You would need to do a little more than suggested by Jisss shyam and you should parametrize your sql statement to avoid sql injection attacks.

You should also consider using check boxes for selecting > < = != because you could have more than one selection criteria in the WHERE clause ie name <= 'smith' OR name >= 'thomas' OR name != 'thompson' AND country = 'mycountry'

You may also want to use conditionals to create your sql statement ie, you would have a check box to include an ORDER BY part or GROUP BY.
Dealy17y ago
Thanks for the info. I will try it and if i have a problem i'll get back :)
Dealy17y ago
I want to have a form with 4 comboboxes. At first combobox user will choose the table, at second will choose the table field, at third will choose criteria (as equal, not equal, between, greater than, less than etc) and at forth combobox will even write the criteria parameter or choose from the list(in case of equal).

With the above user will create its own queries dynamically.
nitin murkute17y ago
Can you please tell us what exactly your requirement is??