Datagrid sorting - need help

[DotNetGnat]

ok here is psuedo code...

 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        If Not Page.IsPostBack Then
            BindData()
        End If
    End Sub

Sub BindData()
        If SortExp.Text = "" Then
            dgdata("ApprovalDate asc")
        Else
            dgdata(SortExp.Text)
        End If

    End Sub

Sub dgdata(ByVal SortField As String)
'code binding the data to the datagrid
end sub

  Sub SortCommand_OnClick(ByVal Sender As Object, ByVal E As DataGridSortCommandEventArgs)

        dgdata(SortOrder(E.SortExpression).ToString())

    End Sub

Function SortOrder(ByVal Field As String) As String

        Dim so As String = SortExp.Text
        If Field = so Then
            SortOrder = Replace(Field, "asc", "desc")
        Else
            SortOrder = Replace(Field, "desc", "asc")
        End If
    End Function

what am i doing wrong here...the sorting works on the first click but doesnt work on the second click... i wanted it to work both ways...it has got to do something with the post back thing or binding the data again...but not sure where to fix it in the code...

-DNG

 

[jbenson001]

I don't see where you are calling the Sort_Command function.

Jim

 

[ca8msm]

Also, try following the walkthrough from 4Guys:

http://aspnet.4guysfromrolla.com/articles/052202-1.aspx

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[DotNetGnat]

sort command function is in the datagrid on the aspx page...

<asp: datagrid ......>
....AllowSorting="True" OnSortCommand="SortCommand_OnClick">

-DNG

 

[jbenson001]

What do you mean it does not work on the second click? Is it just not sorting, or do you not see any data in the grid?

 

[DotNetGnat]

i see the datagrid and everything works fine...it just doesnt sort the next time...i mean when the datagrid is initially displayed on the pageload, it is sorted by the default...when i click on some other column it works fine and sorts ok...and when i click the same column again thinking it will sort the other way round...it doesnt sort...i am thinking that i need to bind the datagrid data again?? do i??

-DNG

 

[jbenson001]

DNG,

We have done this dance in an earlier thread:

thread855-1130440

Jim

 

[mj616]

You need to check if your initial field is the current sort field if it is then switch direction from asc, to desc and vice versa.