GridView Sorting without ViewState

Question

0.00/5 (No votes)

See more:

I’m trying to implement a Sort feature for my GridView that is being populated from a DataTable. Also I have a Filter/Search feature so I can’t use ViewState cause every time the Filter /Search results are displayed and I try to Sort them the Sort displays all the records then Sorts them.

This is the only code that I found that doesn't use a ViewState but, it doesn't work. Whenever I click on the column hearder nothing happens. Just my message 'Empty' pops-ups.

VB

Private Function ConvertSortDirectionToSql(ByVal sortDirection As SortDirection) As String
        Dim newSortDirection As String = String.Empty

        Select Case SortDirection
            Case SortDirection.Ascending
                newSortDirection = "ASC"

            Case SortDirection.Descending
                newSortDirection = "DESC"
        End Select

        Return newSortDirection
    End Function

    Protected Sub grdNurseVisits_Sorting(ByVal sender As Object, ByVal e As GridViewSortEventArgs) Handles grdNurseVisits.Sorting

        Dim dtable As DataTable = TryCast(grdNurseVisits.DataSource, DataTable)

        If Not dtable Is Nothing Then
            MsgBox("Not Empty")
            Dim dataView As DataView = New DataView(dtable)
            dataView.Sort = e.SortExpression & " " & ConvertSortDirectionToSql(e.SortDirection)

            grdNurseVisits.DataSource = dataView
            grdNurseVisits.DataBind()
        ElseIf dtable Is Nothing Then
            MsgBox("Empty")
        End If
    End Sub

Posted 18-Nov-13 7:23am

Commish13

Updated 18-Nov-13 9:14am

RaisKazi

v2

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2014-02-11T02:30:00

Solution 1

Check these
GridView sorting with ViewState off - a solution to double querying and "why doesn't my Sorting event handler fire?"[^]
GridView Sorting, Paging without using Session, ViewState or Cache[^]

Posted 11-Feb-14 2:30am

thatraja

woopsydoozy · Answer 2 · 2014-02-11T05:34:00

Is this a Windows or web app? DataGridView is Windows, but you're talking about ViewState, so I assume you've got a web app with a GridView. Assuming that's the case, you're getting your "Empty" message every time because your grid's data source is nothing on postback (which is normal). If you want access to the data source, add it to ViewState at the same time you bind it, and then fetch it out here in the sort handler. And this will also address your primary question: when you apply your sort, you are rebinding, so you need to preserve and re-apply any filter that is present as well. Something like this:

VB

Using dv As New DataView(ViewState(MY_DATA))
    dv.Sort = e.SortExpression & " " & ConvertSortDirectionToSql(e.SortDirection)
    ViewState(MY_SORT) = dv.Sort
    If ViewState(MY_FILTER) IsNot Nothing Then dv.RowFilter = ViewState(MY_FILTER) 'preserve current filter
    grdNurseVisits.DataSource = dv
    grdNurseVisits.DataBind()
End Using

GridView Sorting without ViewState

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

GridView Sorting without ViewState

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us