EnableSortingan dPagingCallback when

[jobs]

I have a gridview that is refreshes when a dropdown is selected outside
of it. Sorting is enabled on the gridview but not working.

I read that I should set EnableSortingan dPagingCallback to true to fix
the error:

The GridView 'GridView1' fired event Sorting which wasn't handled

However, I am now getting:

Callbacks are not supported on CommandField when the select button is
enabled because other controls on your page that are dependent on the
selected value of 'RatePlanGridVi ew' for their rendering will not
update in a callback. Turn callbacks off on 'RatePlanGridVi ew'.

Paging on the gridview appears to work fine, because I added these:

Protected Sub RatePlanGridVie w_PageIndexChan ged(ByVal sender As
Object, ByVal e As System.EventArg s) Handles
RatePlanGridVie w.PageIndexChan ged
.. and I rebind (but I don't see code to set the new page)

End If

Protected Sub RatePlanGridVie w_PageIndexChan ging(ByVal sender As
Object, ByVal e As GridViewPageEve ntArgs) Handles
RatePlanGridVie w.PageIndexChan ging
RatePlanGridVie w.PageIndex = e.NewPageIndex
RatePlanGridVie w.DataBind()
End Sub
I get the noted error under

Protected Sub RouteCodesList_ SelectedIndexCh anged
when I attempt to bind.
The gridview is configured as follows:

<asp:GridView ID="RatePlanGri dView" runat="server"
AutoGenerateCol umns="False" DataKeyNames="R outeCode"
Width="700px" SkinID="GridVie w"
AllowPaging="Tr ue" AllowSorting="t rue" ShowFooter="tru e"
PagerSettings-Mode="NumericFi rstLast">
Is there an event for sorting I should set, and will I have to take of
sorting myself?

[jobs]

onsorting="Grid view_sorting"

and

Protected Sub GridView_Sortin g(ByVal sender As Object, ByVal e As
GridViewSortEve ntArgs)
...

End Sub

Can somebody point me in the right direction in how to finish this, I
presume with e.sortdirection and/or e.sortexpressio n. I found some C#
code I tried to convert, but vb.net knows nothing about
ConversionHelpe rs or CovertSortDirec tionToSQL. I am unclear about how
the sorting is even going to work.

Protected Sub RatePlanGridVie w_Sorting(ByVal sender As Object,
ByVal e As GridViewSortEve ntArgs)
Dim dataTable As DataTable =
CType(Conversio nHelpers.AsWork around(RatePlan GridView.DataSo urce,
GetType(DataTab le)), DataTable)
If Not (dataTable Is Nothing) Then
Dim dataView As DataView = New DataView(dataTa ble)
dataView.Sort = e.SortExpressio n + " " +
ConvertSortDire ctionToSql(e.So rtDirection)
RatePlanGridVie w.DataSource = dataView
RatePlanGridVie w.DataBind()
End If

[jobs]

The Grid displays with multiple rows. I select to sort of a particular
field and the below event is fired, but DataTable is Nothing so code is
skipped.
Protected Sub ChargeGridView_ Sorting(ByVal sender As Object, ByVal e
As GridViewSortEve ntArgs)
Dim dataTable As DataTable = CType(ChargeGri dView.DataSourc e,
DataTable)
If Not (dataTable Is Nothing) Then '****** (THIS IS ALWAYS
FALSE) ****
Dim dataView As DataView = New DataView(dataTa ble)
dataView.Sort = e.SortExpressio n + " " + e.SortDirection
Response.Write( e.SortExpressio n + " " + e.SortDirection )
ChargeGridView. DataSource = dataView
ChargeGridView. DataBind()
End If
End Sub

The GridView:

<asp:GridView ID="ChargeGridV iew" runat="server"
AutoGenerateCol umns="False" DataKeyNames="R outeCode"
Width="700px" SkinID="GridVie w"
AllowPaging="Tr ue" AllowSorting="t rue"
OnSorting="Char geGridView_Sort ing" ShowFooter="tru e"
PagerSettings-Mode="NumericFi rstLast">