Filtering on IS NULL

[RB]

I have a radgrid with a dropdown template for filtering. If there are null values, the dropdown displays a blank row.On click of this nothing happens. How can I catch this and display IS NULL?

void RadComboBoxControl_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
       {
           string filterExpression;
           filterExpression = "([" + colname + "] ='" + e.Value + "')";
           if (e.Value.Equals("All"))
               filterExpression = " ";
           radgrid.MasterTableView.FilterExpression = filterExpression;
           selectedValue = e.Value;
           radgrid.MasterTableView.Rebind();
       }

if (e.Value.Equals(""));

what should the filterExpression be so that all NULL rows are filtered.

[Eyup]

Hi Ruchi,

Please note that modifying the FilterExpression is quite tricky and it can be error-prone, therefore, it is not recommended. Instead, you can use the filter client-side method:
http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/filtering/filter-templates/defaultcs.aspx

In addition, I'm attaching a sample RadGrid web site to demonstrate a similar implementation with Null values.

Hope this helps.

Regards,
Eyup
Telerik