How to apply filter using BindingSouce?

Answer:

Suppose you have table with column col1, col2, col3, col4 and you want to filter the record where col1 is equal to Lakhan and col2 like G
bindingSource1.Filter="col1 = 'Lakhan%' AND col2 LIKE 'G%'"

here bindingSource1 is the object of BindingSource Class.