我的代码是这样的,后台:
Protected Sub GridView1_Sorting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewSortEventArgs) Handles GridView1.Sorting
Dim sortEx As String
sortEx = e.SortExpression
If ViewState("SortOrder").ToString = sortEx Then
If ViewState("OrderDire").ToString = "desc" Then
ViewState("OrderDire") = "asc"
Else
ViewState("OrderDire") = "desc"
End If
Else
ViewState("SortOrder") = e.SortExpression
End If
Call gridsort()
End Sub
Private Sub gridsort()
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("connstr").ConnectionString
conn.Open()
sda = New System.Data.SqlClient.SqlDataAdapter(strsql, conn.ConnectionString)
sda.Fill(ds, "sorttable")
view = ds.Tables("sorttable").DefaultView
Dim sortname As String = ViewState("SortOrder") + " " + ViewState("OrderDire")
view.Sort = sortname
GridView1.DataSource = view
GridView1.DataBind()
conn.Close()