BindingSource.Filter = "Col1='" & sumtymsnullsumtymsnot & "'"

[nev]

Does anyone know how to do that? In my real project actually, I filter on two fields like this...

bindingsource.f ilter = "col1='" & var1 & "' AND col2='" & var2 & "'"

wherein var1 or var2 may contain a null value. Its just the same as if I want to show all records with null values.

Any ideas?

[Murugs]

Try the below code.
dv.RowFilter = "(Isnull(col1,' Null Column') = 'Null Column' or Isnull(col2,'Nu ll Column') = 'Null Column') or (col1='TEST' and col2='TEST')";
Hope it will solve ur problem.

Cheers,
Murugs.

[nev]

Try the below code.
dv.RowFilter = "(Isnull(col1,' Null Column') = 'Null Column' or Isnull(col2,'Nu ll Column') = 'Null Column') or (col1='TEST' and col2='TEST')";
Hope it will solve ur problem.

Cheers,
Murugs.

thanks for the input.