Pieter Jelle
Top achievements
Rank 1
Rank 1
Pieter Jelle
asked on 12 Apr 2011, 01:38 PM
I'm new to the teleric-controls.
I was having a look at an issue where the GridDateTimeColumn of the RadGrid didn't seem to working accordingly. The problem is the filter where the date-format of the database is different then the one displayed in the Grid. I have set the DataFormatString to {0:yyyy-MM-dd}, whereas in the database it is formatted to yyyy-MM-dd. When entering the date in the "filter-box" it also changes to a format that is different then the one expected (it seems to have turned the date around; for instance, yyyy-MM-dd-format has been dd-MM-yyyy-format).
I have been looking in the forums, but can't find a solution that quickly.
Kind Regards,
Pieter
I was having a look at an issue where the GridDateTimeColumn of the RadGrid didn't seem to working accordingly. The problem is the filter where the date-format of the database is different then the one displayed in the Grid. I have set the DataFormatString to {0:yyyy-MM-dd}, whereas in the database it is formatted to yyyy-MM-dd. When entering the date in the "filter-box" it also changes to a format that is different then the one expected (it seems to have turned the date around; for instance, yyyy-MM-dd-format has been dd-MM-yyyy-format).
I have been looking in the forums, but can't find a solution that quickly.
Kind Regards,
Pieter
1 Answer, 1 is accepted
0
Pieter Jelle
Top achievements
Rank 1
Rank 1
answered on 13 Apr 2011, 06:33 PM
The issue had to do quite possibly with a LinqDataSource that wasn't used with this grid, but instead a custom DataSource. As I am no longer working for this company, I have currently no more updates concerning this issue.
I did a test and the filter problem doesn't occur when you use a LinqDatasource and setting the DataFormatString of the GridDateTimeColumn accordingly (that is, dd-MM-yyyy-format in my case).
I did a test and the filter problem doesn't occur when you use a LinqDatasource and setting the DataFormatString of the GridDateTimeColumn accordingly (that is, dd-MM-yyyy-format in my case).