I have made a dataTableAdapter and defined it as a source for my radGrid. Everything is fine, I am getting all columns from my table but have changed datetime format using DATEADD(dd, 0, DATEDIFF(dd, 0, DateTime)). Now i just need to sort all my records in descending order (thats it latest ones first). So I have tried sorting it in my query using Order By clause and through sortExpressions in radGrid as well. But its not working...please help me!
1 Answer, 1 is accepted
0
Hello saadi,
Which field are you using in order by clause or grid sorting expressions? Is it the original date field there or the formatted one? I suggest that you use the original field in this case.
Additionally, you can review the below topics for more information about grid sorting:
http://www.telerik.com/help/aspnet-ajax/grdbasicsorting.html
http://www.telerik.com/help/aspnet-ajax/grdsortingexpressions.html
Check it out and let me know how it goes.
Best wishes,
Iana
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Which field are you using in order by clause or grid sorting expressions? Is it the original date field there or the formatted one? I suggest that you use the original field in this case.
Additionally, you can review the below topics for more information about grid sorting:
http://www.telerik.com/help/aspnet-ajax/grdbasicsorting.html
http://www.telerik.com/help/aspnet-ajax/grdsortingexpressions.html
Check it out and let me know how it goes.
Best wishes,
Iana
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.