SQL Server DateTimeoffset data type field not shown in RadGrid

1 Answer 115 Views
Grid
Roger
Top achievements
Rank 2
Iron
Iron
Iron
Roger asked on 06 May 2021, 08:17 PM

I have a radgrid set to a datatable.  Columns of type DateTimeOffset are hidden.

Why is this?

 

Roger

1 Answer, 1 is accepted

Sort by
0
Accepted
Vessy
Telerik team
answered on 11 May 2021, 02:56 PM

Hi Roger,

The faced behavior is caused due to the fact the Grid does not support DateTimeOffset object type yet: https://feedback.telerik.com/aspnet-ajax/1374084. You can add your vote and Follow the issue to get notifications of its progress.

At this point the only workaround I can offer is converting the DateTimeOffset value from the data source to a DateTime value: https://msdn.microsoft.com/en-us/library/bb546101(v=vs.110).aspx#Anchor_1.

Regards,
Vessy
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Roger
Top achievements
Rank 2
Iron
Iron
Iron
commented on 11 May 2021, 06:10 PM

Thanks for the answer.
Vessy
Telerik team
commented on 12 May 2021, 06:26 AM

You are welcome, Roger :)
Tags
Grid
Asked by
Roger
Top achievements
Rank 2
Iron
Iron
Iron
Answers by
Vessy
Telerik team
Share this question
or