Why does Gridview Page IndexChanging works in f/w direction only?

Question

1.00/5 (1 vote)

See more:

Good Morning guys,

My Gridview page only works from 1st page to 2nd and to 3rd...
But if I am on 3rd page and click on 2nd or 1st it doesn't do anything, instead just sits on page 3 itself.
Here is my code

SQL

<asp:GridView ID="gdvAll" runat="server" AllowPaging="true" PageSize="10" AllowSorting="true"
                               Style="vertical-align: middle;" HorizontalAlign="Center" OnPageIndexChanging ="ongdvPageIndex_Clicked"
                               AutoGenerateColumns="false" OnSelectedIndexChanged="OnSelectedIndexChanged" EnableSortingAndPagingCallbacks="true"
                               CssClass="Grid" AlternatingRowStyle-CssClass="alt" PagerStyle-CssClass="pgr">

Protected Sub ongdvPageIndex_Clicked(ByVal Sender As Object, ByVal e As GridViewPageEventArgs)
    Try
        gdvAll.PageIndex = e.NewPageIndex
        gdvAll.DataSource = ViewState("gdvAll")
        gdvAll.DataBind()
    Catch ex As Exception
        LogError.LogErrorIntoTextFile(ex, "ongdvPage_Clicked()")
    End Try
End Sub

Can anyone figure out this weird behavior of pages in Gridview?

Posted 25-Feb-15 2:47am

sudevsu

Add a Solution

Comments

sudevsu 25-Feb-15 9:29am

I have two update panels in same page. Do you think that is the cause of this weird behavior?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

teledexterus · Answer 1 · 2015-02-25T03:34:00

I believe your ViewState("gdvAll") is a dataset from another Subroutine with some sort of SQL or other. This code will sort the data by Ascending or Descending alleviating you Page Problem:

VB

Protected Sub gdvAll_OnSorting(ByVal sender As Object, ByVal e As GridViewSortEventArgs) Handles GridView1.Sorting
      Dim sortingdirection, sortby
      If e.SortDirection = "ASC" Then
          sortingdirection = "DESC"
      Else
          sortingdirection = "ASC"
      End If
      sortby = e.SortExpression & " " & sortingdirection
      Dim MyDataSet As New DataSet = ViewState("gdvAll")
      Dim MyDataTable As New DataTable()
      MyDataTable = MyDataSet.Tables(0)
      Dim MyDataView As New DataView(MyDataTable)
      MyDataView.Sort = sortby
      gdvAll.DataSource = ViewState("gdvAll")
      GridView1.DataBind()
  End Sub

SQL

<asp:GridView ID="gdvAll" runat="server" AllowPaging="true" OnPageSize="10" AllowSorting="true"  OnSorting="gdvAll1_OnSorting"
                               Style="vertical-align: middle;" HorizontalAlign="Center" OnPageIndexChanging ="ongdvPageIndex_Clicked"
                               AutoGenerateColumns="false" OnSelectedIndexChanged="OnSelectedIndexChanged" EnableSortingAndPagingCallbacks="true"
                               CssClass="Grid" AlternatingRowStyle-CssClass="alt" PagerStyle-CssClass="pgr">