Item command default sort functionality passthrough

[Scott Hannon]

Please excuse if this is a duplicate, but did not find anything using search.

I have a grid using Grid_ItemCommand like so. If I want the built-in sorting functionality to continue to work, what do I put in the "case sort" :

Protected Sub rgOrderStats_ItemCommand(sender As Object, e As Telerik.Web.UI.GridCommandEventArgs) Handles rgOrderStats.ItemCommand
       Select Case e.CommandName
           Case "RowClick" 'show detail grid
               Dim index As Integer = e.Item.ItemIndex
               Dim item As GridDataItem = rgOrderStats.Items(index)
               'Get the values from the row using the columnUniqueName
               Dim id As String = item("HID").Text
               Session("hid") = id
               'call detail
               'show radwindow with grid
               ScriptManager.RegisterStartupScript(Me.Page, Page.GetType(), "popgrid", "openDetail();", True)
           Case ("RebindGrid") 'refresh
               rgOrderStats.Rebind()
           Case "ExportToPdf"
               rgOrderStats.MasterTableView.ExportToPdf()
           Case "ExportToWord"
               rgOrderStats.MasterTableView.ExportToWord()
           Case "ExportToXLS"
               rgOrderStats.MasterTableView.ExportToExcel()
           Case "Sort"
               '??
       End Select

   End Sub

[Shinu]

Hello,

If you want to sort the entire grid in the ItemCommand event.Try the following code.
VB:

rgOrderStats.AllowSorting = True

You can also set  SortExpression as shown below.
VB:

Dim sortExpr As New GridSortExpression()
sortExpr.FieldName = "FieldName"
sortExpr.SortOrder = GridSortOrder.Ascending
rgOrderStats.MasterTableView.SortExpressions.AddSortExpression(sortExpr)

-Shinu.

[Scott Hannon]

Thanks, Shinu.
I tried the AllowSorting = True, but this did not actually make the grid use the default built-in sorting functionality. I do not want to manually manage the sorting. Currently, when I click a header to sort, the grid goes blank. Is there some method to pass sort control back to the grid itself?

[Shinu]

Hello Scott,

I suppose this issue arises because you are using simple databinding to bind the grid. For implementing advanced features such as sorting, paging etc RadGrid must be bound using declarative data sources or through the NeedDataSource event. Check the following help documentation which explains more about this.
Advanced Data-binding (using NeedDataSource event).

-Shinu.

[Scott Hannon]

I ended up using this in the Case "Sort":

Dim sortExpr As New GridSortExpression()
sortExpr.FieldName = DirectCast(e, GridSortCommandEventArgs).SortExpression '"FieldName"
sortExpr.SortOrder = DirectCast(e, GridSortCommandEventArgs).NewSortOrder 'GridSortOrder.Ascending
rgOrderStats.MasterTableView.SortExpressions.AddSortExpression(sortExpr)

Then did a ReBind().