bindingsource.filter

i am using bindsource to filter the records.my requirement is filtering the record of the same column which contains multiple rows.Here is the snippet:


bindingsource.filter="code='01','02'";
It throws an error.
what is the perfect syntax?
Thnx in advance

Try something like this;

bindingsource.filter="code='01' OR code='02'";

i want to show both 01 and 02 records.But yours only show either one

i think it should work with the OR.

try to use like this:

  bindingsource.filter = "code in ('01','02')";

 

I am not sure but can u give try for some of the following;

bindingsource.filter="code IN ('01','02')";

Or

bindingsource.filter="code ='01';'02')";

ITS WORKING

Also I want to know how to filter the unique records throught this binding source