[Solved] InvalidCastException during filter operation

[Clive Hoggar]

Hi all

I have just added a filter to a grid (a list of wines with name, vintage etc).

When I attempt to filter on Vintage I get an InvalidCastException which seems to be
 caused by a Null value for Vintage in one of the records in the database.

How can I allow this filter to work even when there are some null values for
that column?

Thanks for your help!

Clive

[Princy]

Hello Clive,

Try setting the EnableLinqExpressions property of the grid to false and see if it helps. Here's the link to a forum discussion which explains on a similar issue. You should take a look at it.
Filtering IsNull on DateTimeColumn

Hope this helps..
Princy.