facing problem in gridview paging

Question

Dear experts
I am facing problem in gridview paging . i am doing like this
using vb.net as code behind file in asp.net

Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView1.PageIndexChanging

        GridView1.PageIndex = e.NewPageIndex
        GridView1.DataBind()
    End Sub

<asp:GridView ID="GridView1" runat="server" class="grhd" CellPadding="4"
            ForeColor="#333333" GridLines="None" Width="195px" AllowPaging="True"
           PageSize="6" OnPageIndexChanging="GridView1_PageIndexChanging" >
</asp:GridView>

Mayur Gujrathi · Answer

Thanks everyone for your reply finally i solved it in this way I took my dataset in view state ViewState(dsdata) = ds then on page index changing i did myds = DirectCast(ViewState(dsdata) DataSet) Dim dataView As New DataView(myds.Tables(0)) GridView1.DataSource = dataView GridView1.PageIndex = e.NewPageIndex GridView1.DataBind() dataView = Nothing

Mayur Gujrathi · Answer

I did it but it wont be fitted what i am trying to do

Suthish Nair · Answer

Mayur I suggest you to read the other comments also before using my article.

Mayur Gujrathi · Answer

Dear sutish sir I just see article posted by you sorting_paging without cahingviewstate  i did same changes in my application but my problem is that i am sending 2 parameters to stored procedure on button click and when i did Dim dataView As New DataView(ds.Tables(0)) GridView1.DataSource = dataView GridView1.PageIndex = e.NewPageIndex GridView1.DataBind() dataView = Nothing on page index changing it says table 0 not found because i think it is not getting parameter what might be solution on button click i am doing like this Dim cmd = New SqlCommand Dim constr = ConfigurationManager.AppSettings(PooledConnectionString) Dim sqlcon As SqlConnection = New SqlConnection(constr) Dim da As SqlDataAdapter = New SqlDataAdapter(select * from dp_acct_mstr  sqlcon) da.SelectCommand = cmd cmd.Connection = sqlcon cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = PR_SELECT_CLIENT_TARRIFF Dim todate As Date Dim fromdate As Date fromdate = ClsDate.GetFormatedDate(hdFromDate.Value DD/MM/YYYY) todate = ClsDate.GetFormatedDate(hdTodate.Value DD/MM/YYYY) cmd.Parameters.AddWithValue(@PA_FROM_DT fromdate) cmd.Parameters.AddWithValue(@PA_TO_DT todate) da.Fill(ds PR_SELECT_CLIENT_TARRIFF) If (Not (ds.Tables(0).Rows.Count > 0)) Then Label1.Visible = True Label1.Text = No Records Found From Selected Date txtfromdt.Value = fromdate txttodt.Value = todate ElseIf ds.Tables(0).Rows.Count > 0 Then Dim rowcount As Integer rowcount = ds.Tables(0).Rows.Count Label1.Visible = True ' & rowcount &  Label1.Text = Records Found  & rowcount &  From selected date. GridView1.DataSource = ds.Tables(0) GridView1.DataBind() txtfromdt.Value = fromdate txttodt.Value = todate End If and declaring a variable dataset ds in declarations

Suthish Nair · Answer

Mayur did you check the articles from Our recommended articles section on right side. Already have samples provided.

Mayur Gujrathi · Answer

Anyone?

Mayur Gujrathi · Answer

still not solved

piyush sardhara · Answer

PageIndexChanged event to fill gird view and also use page index changing

Mayur Gujrathi · Answer

no page index changed is not working?

piyush sardhara · Answer

if you get that problem then you can use page index changed event and bind gird on that event

kritika · Answer

hey i think you need to write suppose like GridView1.DataSource = your method to get data; GridView1.DataBind();

Mayur Gujrathi · Answer

sorry i forgot to mention the problem whenever i am clicking on next no. data is not displaying only blank page is displayed

Karthikeyan Anbarasan · Answer

What problem u are facing?

kritika · Answer

hey hi ... what type of problem you are facing..?