Sorting in GridView using VB.NET

Question

I need to sort gridview in ascending and descending order with arrow signs in column header. I have done with column header. I want to add up and down arrow to sort the gridview for all the columns. Attached zip file is my code. Thanks Aakash

Thiruppathi R · Answer

Private Const ASCENDING =  ASC Private Const DESCENDING =  DESC Public Property GridViewSortDirection() As SortDirection Get If ViewState(sortDirection) Is Nothing Then ViewState(sortDirection) = SortDirection.Ascending End If Return DirectCast(ViewState(sortDirection) SortDirection) End Get Set ViewState(sortDirection) = value End Set End Property Protected Sub GridView1_Sorting(sender As Object e As GridViewSortEventArgs) Dim sortExpression As String = e.SortExpression If GridViewSortDirection = SortDirection.Ascending Then GridViewSortDirection = SortDirection.Descending SortGridView(sortExpression DESCENDING) Else GridViewSortDirection = SortDirection.Ascending SortGridView(sortExpression ASCENDING) End If End Sub Private Sub SortGridView(sortExpression As String direction As String) ' You can cache the DataTable for improving performance Dim dt As DataTable = GetData().Tables(0) Dim dv As New DataView(dt) dv.Sort = sortExpression & direction GridView1.DataSource = dv GridView1.DataBind() End Sub

Akash Salunkhe · Answer

Hi Thiruppathi R GetData() is sub in my program. I'm getting error on that. Kindly reply back