In my grid view are not showing next page

Question

0.00/5 (No votes)

See more:

Hi everyone ,
in gridview who is fetching thousands of records .i allowpaging "true" ,but next page of gridview is not showing data .
Thanks in advance

Posted 11-May-12 22:54pm

kunalkumarsingh

Add a Solution

Comments

Ali Al Omairi(Abu AlHassan) 12-May-12 5:09am

did you handle PageIndexChanging and PageIndexChanged events?

3 solutions

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)

Sandeep Mewara · Answer 1 · 2012-05-11T23:19:00

Solution 1

Apart from setting AllowPaging property to true, you need to handle the PageIndexChanged event where you move to next page and bind the data with grid.

Have a look here on how it is implemented and try out:
MSDN: GridView.PageIndexChanged Event[^]

Posted 11-May-12 23:19pm

Sandeep Mewara

Syed SufiyanUddin · Answer 2 · 2012-05-11T23:38:00

Solution 2

Hello !! Check this It will be Helpfull to u.

Give Allow Paging = True;

and write this below code in PageIndeX changing.

C#

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {

        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataBind();

}

Posted 11-May-12 23:38pm

Syed SufiyanUddin

Comments

kunalkumarsingh 16-May-12 3:43am

I handeled the pageindexchangig event even still not showing next page.

Ubaid ur Rahman IT 16-May-12 4:59am

can u please display ur design and code page here....lets we check and give ua perfect answer.

kunalkumarsingh 28-May-12 5:08am

how to display design and code page here can you help me.
Thank you.

Syed SufiyanUddin 28-May-12 6:36am

Just copy and paste ur code here

kunalkumarsingh 28-May-12 6:46am

protected void btn_viewingrid_Click(object sender, EventArgs e)
{
SqlDataAdapter da = new SqlDataAdapter("select * from CONTAINERSIN where Conti_Depot='" + txt_Dptno.Text + "' ", con);
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void GridView1_PageIndexChanged(object sender, EventArgs e)
{

}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}

// SOURCE CODE

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
CellPadding="0" ForeColor="#333333" GridLines="Horizontal"
AllowPaging="True"
onpageindexchanging="GridView1_PageIndexChanging" onselectedindexchanged="GridView1_SelectedIndexChanged2"
>
<footerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White">
<rowstyle backcolor="#F7F6F3" forecolor="#333333">
<columns>
<asp:BoundField DataField="CONTI_ID" HeaderText="DTL NO" />
<asp:BoundField DataField="Conti_Depot" HeaderText="CONT SIZE" />
<asp:BoundField DataField="CONTI_SHPLINE" HeaderText="CONT NO" />
<asp:BoundField DataField="CONTI_INDATE" HeaderText="SHIPPING LINE" />
<asp:BoundField DataField="Conti_InDate" HeaderText="IN DATE" />

<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<editrowstyle backcolor="#999999">
<alternatingrowstyle backcolor="White" forecolor="#284775">

kunalkumarsingh 28-May-12 6:52am

These are my code.My grid view has more than 2000 records and i want to see these records in paging.If i want see those data without paging then i am getting error " shortage of memory".Help me how to see these data in through paging.
Thanks a lot in advance

Uday P.Singh · Answer 3 · 2012-05-11T23:50:00

Solution 3

Try this:

ASP.Net 2.0 Gridview Paging using C#[^]

hope it helps :)

Posted 11-May-12 23:50pm

Uday P.Singh

Comments

Ranjith Reddy CSE 30-May-12 7:07am

My Dear Friend, Use PageIndexingChanging event......and delete page index changed event....from design and code....may be it will run.

Ranjith Reddy CSE 30-May-12 7:10am

and also delete Selected index changed event also.....ok.