BindingSource.Filter expression as not equal!!

[Hussam Fattahi]

Hi I want to filter a bound grid through binding source filter property. but i couldn't write a filter like this "DocumentID != 1"; it throws an exception saying ! not acceptable. how can i achive this

[Luc Pattyn]

The MSDN page on BindingSource.Filter refers to DataColumn.Expression which shows some operators inluding AND, OR, NOT. And in SQL there isn't a != operator, however there is a basic-like <> operator. At least one of those approaches should do it for you. :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

[Hussam Fattahi]

hi luc, thanks for replay i do read the full page in MSDN before posting here what i want to do is the following i have a list of type int named execludedFields which holds the codes for unwanted records i want to loop through the collection to build a filter like this "FieldCode != 1 OR FieldCode != 5 .... and so on" i couldn't figure out how to do it because there is no negative operator of course i can do it the other way around by getting a list called watntedFields but that requires a lot coding more than using the execludedFields approach so I'm asking if there is a way to build a filter that do that using the Filter property

[Luc Pattyn]

1. I already told you what I know about the subject. 2. why bother?

Hussam Fattahi wrote:

FieldCode != 1 OR FieldCode != 5

is always true! :) PS: and then there are parentheses, handy when the default operator precedence is not what you want, e.g. with a NOT operator.

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

[Hussam Fattahi]

sorry, my Bad i meant AND by using NOT do you mean i can write it like this NOT( FieldCode = 1 AND FieldCode = 5 ....) or like this NOT( FieldCode IN(1,5,...)) thanks again

[Luc Pattyn]

I don't know. Try it, or search for documentation or examples. :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.