DefaultView.RowFilter query language

[shawne]

Two questions,

1.) Is there a way to do a "inverse" filter? For instance. I have a datagridview with a list of all software installed on my machine. There are two basic filters I would like to use. One, view only updates. This one I have figured out. The other option would be the inverse to this. Exclude updates. In this filter I only want to see applications that were installed, not the updates.

2.) Somewhere I thought I had found a site which showed me the "query" language the filter uses. Anyone have such a link?

Thanks!

 

[MattP]

Using the NOT operator should turn your expression around.

RowFilter Expressions: DataColumn.Expression Property (System.Data)

 

[jmcilhinney]

Matt has provided the requested link but you should have been able to find it for yourself. The MSDN documentation for the DataView.RowFilter property specifically states:

See the Expression property of the DataColumn class for more information.

and provides the link. Always read the documentation first.

 

[shawne]

Using the NOT operator should turn your expression around.

RowFilter Expressions: DataColumn.Expression Property (System.Data)

Thanks Matt for the link!