Hi
I've developed a web application which relies heavily on the radGrid. Now I've encountered a very serious issue, which I consider a serious bug really.
So ... I've got a grid bound to a datatable (using needDataSource event).
I've got a DateTime column in the grid, which shows a column from the datatable, which is fine up until this point.
Then I've got filtering enabled, which is where my problem lies. If I try to filter on a value (equals), it works like a charm. However if I try 'isNull' or 'isNotNull' things go haywire.
Basically 'isNull' shows everything and the other way around. Basically nothing is null. Why is this?
Well ... I'd say it's because it's not 'null', but 'DBNull'. After all, a datatable built using dataAdapter.fill contains dbnull values instead of regular .net null values.
Of course this is not just limited to this type of column, even a regular bound column with a string value has the same issue. Neither 'isEmpty' nor 'isNull' works.
Anyway, this should really be built into the grid as a grid is used to bind data from a database in 99% of the cases it's used.
The client of course is not happy with this. Can anyone come to my aid here and propose a proper way to make this filter work?
I've developed a web application which relies heavily on the radGrid. Now I've encountered a very serious issue, which I consider a serious bug really.
So ... I've got a grid bound to a datatable (using needDataSource event).
I've got a DateTime column in the grid, which shows a column from the datatable, which is fine up until this point.
Then I've got filtering enabled, which is where my problem lies. If I try to filter on a value (equals), it works like a charm. However if I try 'isNull' or 'isNotNull' things go haywire.
Basically 'isNull' shows everything and the other way around. Basically nothing is null. Why is this?
Well ... I'd say it's because it's not 'null', but 'DBNull'. After all, a datatable built using dataAdapter.fill contains dbnull values instead of regular .net null values.
Of course this is not just limited to this type of column, even a regular bound column with a string value has the same issue. Neither 'isEmpty' nor 'isNull' works.
Anyway, this should really be built into the grid as a grid is used to bind data from a database in 99% of the cases it's used.
The client of course is not happy with this. Can anyone come to my aid here and propose a proper way to make this filter work?