[RESOLVED] How to merge BindingSource filters?

[LuxCoder]

I am trying to merge two filters but it aint happening:

ClientProfileBindingSource.Filter = "ClientType = '" & "Seeker" & "'" And "ClientType = '" & "Both" & "'"

error:

Conversion from string "ClientType = 'Seeker'" to type 'Long' is not valid.

please help.

[jmcilhinney]

The problem with your code is that you have the 'And' OUTSIDE the literal string instead of inside. As such it's being treated as a logical operator with those two strings as arguments instead of as part of the string. You can change your code form this:

ClientProfileBindingSource.Filter = "ClientType = '" & "Seeker" & "'" And "ClientType = '" & "Both" & "'"

to this:

ClientProfileBindingSource.Filter = "ClientType = '" & "Seeker" & "' AND ClientType = '" & "Both" & "'"

and it will work.

That said, if that is your real code then all the & operators are unnecessary. You're just joining multiple literal strings so all you need is a single literal string:

ClientProfileBindingSource.Filter = "ClientType = 'Seeker' AND ClientType = 'Both'"

I'll assume that your real code isn't like that but rather you are actually using variables for the two values. In that case, this is a perfect candidiate for the String.Format method:

ClientProfileBindingSource.Filter = String.Format("ClientType = '{0}' AND ClientType = '{1}'", "Seeker", "Both")

You would use your variables in place of the last two arguments. Isn't that clearer?

Finally, how can the same ClientType value be equal to "Seeker" and "Both" at the same time? Should you maybe be using OR rather than AND?

[LuxCoder]

Thank you Sir, Your last statement did the trick