I m using c sharp and i have to build a windows form to support advanced filter. i m using a binding source and i have to set the filter string programmatically.
form has 5 combos to show fields of the table,
5 combos containing values as 'Contains','equals to','begin with','end with','greater than' etc (criteria)
5 text boxes to enter value,
4 group boxes with containing two radio buttons as 'AND' and 'OR'
After selecting any number of combos and set values and click the filter button, the grid should be filtered.
User can select one combo or multiple combos to set the filter. How may i do this? if user select a value such as 'contains ' i should have to set the filter string such as 'LIKE %'.
View Complete Post