[RESOLVED] Grid view Sorting

[achor]

Hello all,

I've searched here and in google for my problem. But what I didn´t found what i was looking for (lol looks like the U2 song)...

Anyway, I have a gridview with paging implemented.

And now what i want is to add the sorting feature to it.

So far I have:

<asp:GridView ID="GridView1" allowpaging="True" allowsorting="True" runat="server"
                CssClass="DataWebControlStyle" CellPadding="4" Font-Names="Verdana" Font-Size="X-Small" 
                AutoGenerateColumns="False" ForeColor="#333333" GridLines="None" 
Width="496px" CellSpacing="2" 
                PageSize="15" datakeynames="NID" 
emptydatatext="No data available."   
                onpageindexchanging="GridView1_PageIndexChanging" OnSorting="GridView1_Sorting">
                
                <HeaderStyle CssClass="HeaderStyle" BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                <AlternatingRowStyle CssClass="AlternatingRowStyle" BackColor="White" ForeColor="#284775" />
                <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                <EditRowStyle BackColor="#999999" />
                <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                
                <Columns>
                    <asp:BoundField DataField="Product" HeaderText="Product"><ControlStyle Width="40px" />
                        <ItemStyle Width="200px" />
                    </asp:BoundField>
                    <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="name" >
                        <ItemStyle Width="200px" />
                    </asp:BoundField>
                </Columns>
                    </asp:GridView>
                <asp:Label ID="Message" runat="server" ForeColor="Red"></asp:Label>

And in the aspx.vb page I have:

 
Protected Sub GridView1_Sorting(ByVal sender As Object, ByVal e As GridViewSortEventArgs)

        GridView1.Sort(e.SortExpression, SortDirection.Ascending)
        GridView1.DataBind()
    End Sub

but this isn't working, when I click in collumn "Nome" the error is:

An unhandled exception of type 'System.StackOverflowException' occurred in System.Web.dll

Some help?

regards,

[vbdotnetboy]

how/where are you binding the data initially? ie where you assign the gridview's datasource

[vbdotnetboy]

the way i perform manual paging and sorting... keep in mind i just pulled this from one of my apps

Private Property GridViewPageIndex() As Integer
        Get
            If ViewState("GridViewPageIndex") IsNot Nothing Then
                Return ViewState("GridViewPageIndex")
            End If
            Return 0
        End Get
        Set(ByVal value As Integer)
            ViewState("GridViewPageIndex") = value
        End Set
    End Property
 
    Private Property GridViewSortDirection() As SortDirection
        Get
            If ViewState("sortDirection") Is Nothing Then
                ViewState("sortDirection") = SortDirection.Ascending
            End If
            Return ViewState("sortDirection")
        End Get
        Set(ByVal value As SortDirection)
            ViewState("sortDirection") = value
        End Set
    End Property
 
    Private Property GridViewSortExpression() As String
        Get
            If String.IsNullOrEmpty(ViewState("sortExpression")) Then
                ViewState("sortExpression") = DBConstants.COL_HISTORICALTRANSACTIONLOG_ID
            End If
            Return ViewState("sortExpression")
        End Get
        Set(ByVal value As String)
            ViewState("sortExpression") = value
        End Set
    End Property
 
    Private Sub ApplyFilter(ByVal direction As String)
        Dim dt As Ril.HistoricalTransactionLogTable = _
            Ril.TransactionManager.GetHistoricalTransactionLogs(QueryClauseCollectionParameter)
        Dim dv As New Data.DataView(dt)
        dv.Sort = GridViewSortExpression + " " + direction
        gvTransactions.DataSource = dv
        gvTransactions.PageIndex = GridViewPageIndex
        gvTransactions.DataBind()
    End Sub
 
    Protected Sub gvTransactions_PageIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles gvTransactions.PageIndexChanged
        If GridViewSortDirection = SortDirection.Ascending Then
            ApplyFilter("ASC")
        Else
            ApplyFilter("DESC")
        End If
    End Sub
 
    Protected Sub gvTransactions_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles gvTransactions.PageIndexChanging
        GridViewPageIndex = e.NewPageIndex
    End Sub
 
    Protected Sub gvTransactions_Sorting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewSortEventArgs) Handles gvTransactions.Sorting
        GridViewSortExpression = e.SortExpression
    End Sub
 
    Protected Sub gvTransactions_Sorted(ByVal sender As Object, ByVal e As System.EventArgs) Handles gvTransactions.Sorted
        If GridViewSortDirection = SortDirection.Ascending Then
            GridViewSortDirection = SortDirection.Descending
            ApplyFilter("DESC")
        Else
            GridViewSortDirection = SortDirection.Ascending
            ApplyFilter("ASC")
        End If
    End Sub

[achor]

Hello vbdotnetboy,

I have an data acess layer:

Dim ServiceAdapter As New GestFacturasTableAdapters.ServicosClienteTableAdapter
Dim rsSecl As GestFacturas.ServicosClienteDataTable

rsSecl = ServiceAdapter.GetServicosdoCliente(Id_Client)
GridView1.DataSource = rsSecl
GridView1.DataBind()

line2: GestFacturasTableAdapters ... GestFacturas is the name of my database.


About your code:

In line 38 what is this DBConstants.COL_HISTORICALTRANSACTIONLOG_ID ?

[vbdotnetboy]

DBConstants.COL_HISTORICALTRANSACTIONLOG_ID is the way we conform allow for easy change. all this is, is just a class that exposes public constants that are strings with the name of the column in a table or database. we also use it for storing the name of tables, views and stored procedures. this way if anything changes within the database say the name has to be changed then all we have to do is change it once within the DBConstants class and it's in affect throughout the rest of the project, rather then having to search through all the project files to find all occurrences. hope this makes sense


also did you get it working?

[achor]

hello!

yes it worked, I made some changes to the code you gave me.

Many thanks