How to get next & previous records using GridView Control in ASP.Net?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Dear Friends,

I have 10 records in my table. Now I have to bind the data into gridview, whenever click on the entire the gridviewrow record displaying another page like Details.aspx. In Detail.aspx page I have two link buttons like Previous, Next. Whenever click on next I want display next gridview row data, in the same whenever click on previous I need display previous gridview row data. If previous & next records are not available the next & previous buttons will be disable.

Thanks in advance.

Posted 26-Oct-14 21:12pm

Member 10021658

Add a Solution

Comments

Rajesh waran 27-Oct-14 8:45am

try to get that 10 id value from your gridview datasource,in (next or prev)button click event,use Response.Redirect() function ,here u can provide Details.aspx with id values . Then use query string on Details.aspx page to get all id values,here you can bind your new grid with id values.

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)

Animesh Datta · Accepted Answer · 2014-10-26T21:23:00

Solution 1

Hello ,
Refer : GridView-Custom-Paging
thanks

Posted 26-Oct-14 21:23pm

Animesh Datta

Comments

Member 10021658 27-Oct-14 3:36am

Dear Animesh,

Thanks for your reply. But in my requirement the Details.aspx output is like,
Id:100, Name: Raju, College: Govt Engg College, City: Bangalore.

Now whenever click on previous I need display 99 Id records in same Details.aspx page, in the same next button I need to display 101 record.

Animesh Datta 27-Oct-14 3:54am

Have you gone through the article ? It is clearly written that
PAGE_SIZE is the total number of records displayed on each page . Here you must set it to 1 . I suggest you to read the article carefully and then implement according to your requirement.

Member 10021658 27-Oct-14 4:41am

Thank you Animesh. It's great help to me.

Animesh Datta 27-Oct-14 5:21am

Welcome dear .Please accept the answer if the problem is solved.

kskumaran · Accepted Answer · 2014-10-27T00:42:00

ASP.NET

<asp:gridview id="GridView1" runat="server" backcolor="White" showfooter="false" xmlns:asp="#unknown">
        AutoGenerateColumns="False" PageSize="5"
        OnPageIndexChanging="GridView1_PageIndexChanging" AllowPaging="True" OnRowCreated="GridView1_RowCreated"   PagerSettings-Position="TopAndBottom" PagerStyle-HorizontalAlign="Left" PagerStyle-Wrap="true" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" Width="100%" GridLines="Both">
<alternatingrowstyle backcolor="AliceBlue" />
<pagerstyle horizontalalign="Center" backcolor="White"></pagerstyle>
<pagersettings position="TopAndBottom" firstpagetext="First" lastpagetext="Last">
        Mode="NumericFirstLast" ></pagersettings>
    <rowstyle forecolor="#000066" horizontalalign="Center" />
<columns></columns>
</asp:gridview>

C#

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


public void BindGrid()
{

sqlcommand cmd=new sqlcommand("select * from tblname",sqlconnection);
    SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds=new DataSet();
da.Fill(ds);
GridView1.DataSource=ds;
GridView1.DataBind();

}