This is a migrated thread and some comments may be shown as answers.

DateTimeColumn filter with DBNulls

4 Answers 73 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Kevin Van Puyvelde
Top achievements
Rank 1
Kevin Van Puyvelde asked on 30 Apr 2010, 10:45 AM
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?

4 Answers, 1 is accepted

Sort by
0
Nikolay Rusev
Telerik team
answered on 30 Apr 2010, 01:14 PM
Hello Kevin,

We are aware of this issue and it has been already resolved. You can download latest internal build within your account.

Regards,
Nikolay
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Kevin Van Puyvelde
Top achievements
Rank 1
answered on 30 Apr 2010, 01:39 PM
Thank you for the information.

The company will be purchasing the control suite (probably over the weekend or monday) and then we'll get this version once we have an activated account to download it.
0
Luc Van der Putten
Top achievements
Rank 1
answered on 12 May 2010, 08:20 AM
Is there any estimate on when the next official release will be released featuring this bugfix?
0
Sebastian
Telerik team
answered on 12 May 2010, 10:08 AM
Hi Luc,

The Q1 2010 SP2 release of our controls is tentatively scheduled for the last week of May. Presently the fix is included in the latest internal build of the controls.

Best regards,
Sebastian
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
Grid
Asked by
Kevin Van Puyvelde
Top achievements
Rank 1
Answers by
Nikolay Rusev
Telerik team
Kevin Van Puyvelde
Top achievements
Rank 1
Luc Van der Putten
Top achievements
Rank 1
Sebastian
Telerik team
Share this question
or