I am using an Object Datasource that is calling a SQL Server stored procedure. It returns 10 records. Two of the columns are datetime columns. When using the DateTime Column in RadGrid, I can filter just fine on the dates. HOWEVER, one record has a NULL value. When I try to filter the column using the IsNull option in the filter drop down menu, NO records are returned. I have looked into my options in the typed dataset tableadapter, but it will not allow me to change the NullValue to anything other than Throw Exception.
Any ideas on how to resolve this issue?
Thanks,
Terry Webster