Hi,
I have a user control with RadGridView bound to the database table.
The table has a DateTimeOffset column.
It seems that the filter doesnt function properly with this DateTimeOffset datatype (the Date time picker in the filter window of the Grid View Column filter doesnt show up, and the options for filtering is constricted to only isEqualTo and IsNotEqualTo. Other options are not available).
I tried binding the columns with DateTime datatype where ever I could bind the grid to a Object (or Property) which is in turn bound to the database column.
But, where ever I need a direct binding to the database, I am not able to do this.
Can you please suggest any alternate solution?
Thanks and regards
Pavan
I have a user control with RadGridView bound to the database table.
The table has a DateTimeOffset column.
It seems that the filter doesnt function properly with this DateTimeOffset datatype (the Date time picker in the filter window of the Grid View Column filter doesnt show up, and the options for filtering is constricted to only isEqualTo and IsNotEqualTo. Other options are not available).
I tried binding the columns with DateTime datatype where ever I could bind the grid to a Object (or Property) which is in turn bound to the database column.
But, where ever I need a direct binding to the database, I am not able to do this.
Can you please suggest any alternate solution?
Thanks and regards
Pavan