By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 959 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

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

nev
100+
P: 251
Does anyone know how to do that? In my real project actually, I filter on two fields like this...

bindingsource.filter = "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?
Nov 6 '07 #1
Share this Question
Share on Google+
2 Replies


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

Cheers,
Murugs.
Nov 6 '07 #2

nev
100+
P: 251
nev
Try the below code.
dv.RowFilter = "(Isnull(col1,'Null Column') = 'Null Column' or Isnull(col2,'Null Column') = 'Null Column') or (col1='TEST' and col2='TEST')";
Hope it will solve ur problem.

Cheers,
Murugs.
thanks for the input.
Jan 28 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.