I worte the code for page index changing but i want to display insecondpage first page records also means clicking on page2

Question

4.00/5 (1 vote)

See more:

Dear Experts,
plz suggest me...i wrote the code for page index changing but i want to display by clicking the page2 the first page records also want to display..means as first pagerecords and second page records..

Here i want to display firstpage record to secondpage records also...
plz help me....

plz help me....the code for that...

my code is..
aspx

XML

<body>
    <form id="form1" runat="server">
    <div>

    <asp:GridView ID="Gridview1" AllowPaging="true"  AutoGenerateColumns="false" PageSize="6" runat="server" DataKeyNames="id" OnPageIndexChanging="gvdetails_PageIndexChanging" Width="300px">
    <Columns>
    <asp:BoundField DataField="id" HeaderText="id"  />
    <asp:BoundField DataField="Name" HeaderText="Name" />
    <asp:BoundField DataField="location" HeaderText="location"/>

    </Columns>

    </asp:GridView>
    </div>
    </form>
</body>

aspx.cs

C#

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGridData();
        }      
    }
    private void BindGridData()
    {
        con.Open();
        string s = "select * from contact";
        SqlCommand cmd = new SqlCommand(s, con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        Gridview1.DataSource = dt;
        Gridview1.DataBind();
    }

    protected void gvdetails_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        Gridview1.PageIndex = e.NewPageIndex;
        BindGridData();
    }

Posted 18-Sep-12 0:50am

Member 9376025

Updated 18-Sep-12 1:25am

v3

Add a Solution

Comments

Tejas Vaishnav 18-Sep-12 9:33am

for your solutions you need to go for lazy loading concept.

Member 9376025 21-Sep-12 5:20am

vaishnav.what is the lazy loading concept.you can explain me..

2 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)

arshad alam · Answer 1 · 2012-09-18T20:10:00

Solution 1

You just need to change the page size. if you want to view previous data

C#

protected void gvdetails_PageIndexChanging(object sender, GridViewPageEventArgs e)
   {
        Gridview1.PageSize=Convert.ToInt32(e.NewPageIndex)*10;
        Gridview1.PageIndex = 0;

       BindGridData();
   }

Posted 18-Sep-12 20:10pm

arshad alam

Comments

Member 9376025 21-Sep-12 5:09am

i used the above code but the secondpage data is displaying upto 10..and on clicking 3rd page all the records is displaying..

arshad alam 22-Sep-12 2:04am

it means that you have only 10x3=30 records

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2012-09-18T23:55:00

For this kind of requirement, I guess you have to store the data in ViewState and show it in the second page.

I can give you one link Preserving state of Checkboxes while paging in ASP.Net GridView Control[^], where it preserves the state of Check Boxes in View State.

You can implement the logic as per your requirements.

All the best.
Happy coding...