consulta

[mjesus20]

yo lo tengo asi


Sub orden(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridSortCommandEvent Args)



dataadapter = New System.Data.SqlClient.SqlDataAdapter(queryString, dbConnection)
dataset = New System.Data.DataSet()
dataadapter.Fill(dataset, "Inventario")
Dim dv As New System.Data.DataView()
dv.Table = dataset.Tables(0)

If viewstate("vcolumna") = e.SortExpression Then
If viewstate("vorden") = "ASC" Then
dv.Sort = e.SortExpression & " " & "DESC"
campoorden.Text = e.SortExpression & " " & "DESC"
viewstate("vorden") = "DESC"
Else
dv.Sort = e.SortExpression & " " & "ASC"
campoorden.Text = e.SortExpression & " " & "ASC"
viewstate("vorden") = "ASC"
End If
Else
viewstate("vcolumna") = e.SortExpression
dv.Sort = e.SortExpression & " " & "ASC"
campoorden.Text = e.SortExpression & " " & "ASC"
viewstate("vorden") = "ASC"
End If

DataGrid1.DataSource = dv
DataGrid1.DataBind()
campoorden.Text = e.SortExpression + " " + viewstate("vorden")

End Sub