Hello:

I want to give the end user the ability to sort the data in an mmGridView by clicking on the Header Text.

I currently have the Header Text so they can click on it.
That calls the event: grdItems_Sorting.
I can capture which column was clicked by looking at e.SortExpression.
I did set up a second function in the business rule to return the data with a different ORDER BY.

But, I can't seem to resort the data without getting new data from the server. I just want to sort the grid.

The following is my grdItems_sorting code:

        If e.SortExpression = "pro_descrip" Then
            Me.oItems.GetInventoryByCustomerNumberDescrip(Me.lcpro_cusfk)
        Else
            Me.oItems.GetInventoryByCustomerNumber(Me.lcpro_cusfk)
        End If
        Me.BindControl(Me.grdItems)
        Session("dsItems") = Me.oItems.DataSet

I am guessing that there is a much, much easier way to do this.

Please note that I am not using a third-party grid.

Thanks in advance,