Filter NULL Values

[Fanis]

Hello,

Is it possible to filter only the null values of a specific Column in GridView?

Thanks

[Dimitrina]

Hi Fanis,

 It depends on how you would like to filter on the null values. How do you imagine the user to tell the Filtering control to filter/show the null values in the respective column?

The best way to do this would be to apply a converter on the column. If you have a null value then use an appropriate string: "null", "undefined" or String.Empty (for example for int? "String.Empty" will be shown by default instead of the null values) . That way in the filtering control you will have an check box with this specific "null" string. After you check it, all the rows containing null values in that column will be shown.

Is this what do you mean, or have I misunderstood your question?

Best wishes,
Didie
the Telerik team

[Fanis]

Hello again,

I come up again with same problem, but the thing now is that I am using data virtualization and I need to filter the null values as they come from the db.

Any suggestions?