Sorting the Datagrid on Date Time

[Shreeja]

Hi, all Can any one please help me out to Sort Datetime Column in a Datagrid (asc or desc)? I am finding problem in the Sort property of Dataview which does not sort the Datetime column in the datagrid properly (Ascending or descending) . I want to avoid using "order by" option in the sql statement . Thanks in Advance Shreeja. ShreejaRajan

[atul_moghe]

hi there, No need to put any extra effort, datatime field also get sorted by the sort expression. There may have some other problem b'coz in my many pages it sorted well. Dim sortField As String = e.SortExpression dv.Sort = sortField dgDisplay.DataSource = dv dgDisplay.DataBind() A R MOGHE.

[Shreeja]

Hi Mr.MOGHE, Thank you for your reply. But this seems like not working for me . The grid column does not get sorted properly on time when you specify AM and PM along with date and time. ShreejaRajan