Sorting the grid view.

[mike55]

I have a grid view that is binded to a dataset. I am trying to implement sorting on the grid.

 

I have succeeded in allowing sort to occur, the only problem that I am having is to specify what sort option, i.e. ASC or DECS to tuser. Here is the code that I am using:

   Protected Sub gVGroups2_Sorting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewSortEventArgs) Handles gVGroups2.Sorting
       Dim myView As DataView
       dsData = Session("GridData")
       myView = dsData.Tables("Groups").DefaultView

       Select Case e.SortDirection
           Case SortDirection.Ascending
               myView.Sort = "Group_Name DESC"
               e.SortDirection = SortDirection.Descending
           Case SortDirection.Descending
               myView.Sort = "Group_Name ASC"
               e.SortDirection = SortDirection.Ascending
       End Select

       Me.gVGroups2.DataSource = myView
       Me.gVGroups2.DataBind()
   End Sub

 

Can anyone suggest a simple way of storing the sort order. I don't want to use an external textbox/label to store the current sort order.

 

Mike55.