Here is the example in MSDN for the Filter property:

// Filter the items to show contacts who are owners.
BindingSource1.Filter = "ContactTitle='Owner'";

Is it a SQL expression or just limited to "=" operator ?

Hi,


No, its not a SQL expression. But you could view it as your statement in a where clause in a select statement...

No, its not just limited to "=" you could use all boolean operators.... >, <, like, etc...





cheers,


Paul June A. Domag

Note that BindingSource doesn't directly support filtering rather it requires the underlying data source to support filtering (which is typically only ADO.NET).  The following link has information on ADO.NET's filtering expressions:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatacolumnclassexpressiontopic.asp

Joe

Hi,


No, its not a SQL expression. But you could view it as your statement in a where clause in a select statement...

No, its not just limited to "=" you could use all boolean operators.... >, <, like, etc...





cheers,


Paul June A. Domag

Note that BindingSource doesn't directly support filtering rather it requires the underlying data source to support filtering (which is typically only ADO.NET).  The following link has information on ADO.NET's filtering expressions:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatacolumnclassexpressiontopic.asp

Joe