Hi,
sorting in grids can easily be done by setting the "SortOrder" proerty of a Column to ASCENDING or DESCENDING.
I now have a problem with a column that contains DateTime values but which also may be NULL. Since SQL Server handles NULL values as the smallest possible value (so NULL < DateTime.MinValue) it will sort any rows with the DateTime column == null to the end of the list when DESCENDING is set as sort order.
I would like to have a sort order where NULL is regarded as the highest possible value so first, all rows with NULL date value are in the list, followed by the highest date value and then sorted down to the lowest date value.
Is there any way how this can be achived in Radzen?
Thanks for your ideas!