Datagrid Sorting

The following link provide lots of articles on web datagrid - http://www.datagridgirl.com/articles.aspx

To handle sorting on datagrid

1) Datagrid properties - allowsorting = true

2) Edit html to add the following code in asp:datagrid tag
allowpaging="True" onsortcommand="dgdList_SortCommand"

3) Do an event handler

Sub dgdList_SortCommand(ByVal Source As Object, ByVal E As DataGridSortCommandEventArgs) Handles dgdList.SortCommand
sortExpression = " ORDER BY " & E.SortExpression
BindGrid()
End Sub

4) BindGrid
In bindgrid procedure, remember to pass the sortExpression to the SQL statement