.NET BindingSource Filter syntax reference

c# .net filter bindingsource
clamp picture clamp · Sep 7, 2009 · Viewed 23.1k times · Source

You can use the Filter property of a BindingSource to do SQL like filtering. For example:

bindingSource.Filter= "Activated = 1"

Is there something like documentation on the exact syntax of this?

I would like to check if a field is not DBNull, so i tried "Field != NULL" but it gives a syntax error.

Answer

Charles Bretana picture Charles Bretana · Sep 7, 2009

The syntax is generally the same as what would you would use in a SQL Where clause, without the "Where", so in this case, it would be 

  bindingSource.Filter = "Field <> NULL";

If you look at msdn docs for BindingSource.Filter you will see this:

"To form a filter value, specify the name of a column followed by an operator and a value to filter on. The accepted filter syntax depends on the underlying data source. If the underlying data source is a DataSet, DataTable, or DataView, you can specify Boolean expressions using the syntax documented for the DataColumn..::.Expression property."

Follow that link to see all the detailed rules

Related questions

OpenFileDialog C# custom filter like 'ABC*.pdf'

Is it possible to specify custom filters like 'ABC*.pdf' which means: "Show all PDF which starts with ABC"? I can only specify *.pdf, *.doc, *.*, etc. Thanks Florian

Read More
How do you implement a custom filter with Lucene.net?

The code below is from the Lucene In Action book (originally in Java). It's for building a list of 'allowed' documents (from a user permission point of view) to filter search results with. The problem is the termsDocs.Read() method …

Read More
How to make an HTTP POST web request

Canonical How can I make an HTTP request and send some data using the POST method? I can do a GET request, but I have no idea of how to make a POST request.

Read More