Code for first next last previous button and display data in page windows C# application

Question

1.00/5 (2 votes)

See more:

hi,
i create windows c# application. in which i put button like first,next, last,previous.
now i want to display record fetch from database , and show in page.
when i click first button then on load time data display first. when i click last then data display last record, when i click previous then data dispaly previous, and when i click next then display data next in c# windows application.
pls help me...

What I have tried:

i tried to create code, but not get succcess. how can i use for loop to use that and display data in load time of page.

Posted 22-Jun-16 21:31pm

Member 11952997

Updated 7-Jul-22 15:19pm

Add a Solution

Comments

Karthik_Mahalingam 23-Jun-16 5:07am

are you fetching all the records at once or on each button click you are getting it from db ?

Member 11952997 23-Jun-16 5:18am

on each button click display record in fields on forms in windows application c#.net.
means examlple- i create regestration form. many record i insert and save in database.
now i want to see first record then click on first button in form and it dispaly first inserted record.
then i want to see last record then click last button and it dispaly last record.
so that...
note- i want to see record in form fields.

Karthik_Mahalingam 23-Jun-16 5:20am

Ok.
Fine
Are you using datatable or list

Member 11952997 23-Jun-16 5:29am

data table.

Karthik_Mahalingam 23-Jun-16 5:30am

ok. what is the table structure, how many columns
does it has ID column ?
what are the controls in the form ?

Member 11952997 23-Jun-16 5:31am

i am not use gridview to show data, i want to retrive or show data on form fields like example- in txtname= jigar , txtaddress=gujarat...this should fill in fields of forms in c#.net.

Karthik_Mahalingam 23-Jun-16 5:32am

ok ..

Member 11952997 23-Jun-16 5:35am

i use textbox, combobox, datetimepicker, and also image button use in form.

Karthik_Mahalingam 23-Jun-16 5:38am

ok cool, i will come up with a demo example.

Member 11952997 23-Jun-16 5:40am

ok.thanks a lot...

Karthik_Mahalingam 23-Jun-16 5:52am

check my solution.

Member 11952997 23-Jun-16 5:55am

i will check now..

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)

Karthik_Mahalingam · Answer 1 · 2016-06-22T23:50:00

use this example build your Form

C#

public partial class Form1 : Form
   {

       public Form1()
       {
           InitializeComponent();
       }

       DataTable dt = new DataTable();
       int index = 0;
       int last = 0;

       private void Form1_Load(object sender, EventArgs e)
       {
           dt.Columns.Add("FirstName");
           dt.Columns.Add("LastName");

           dt.Rows.Add("Moto", "Nexus");
           dt.Rows.Add("Apple", "Iphone");
           dt.Rows.Add("Sony", "Vaio");
           dt.Rows.Add("Samsung", "Edge");

           index = 0;
           last = dt.Rows.Count -1;
           PopulateData();
       }

       private void btnFirst_Click(object sender, EventArgs e)
       {
           index = 0;
           PopulateData();
       }
       private void btnLast_Click(object sender, EventArgs e)
       {
           index = last - 1;
           PopulateData();
       }
       private void btnPrev_Click(object sender, EventArgs e)
       {
           index--;
           index = index <0? 0:index;
           PopulateData();
       }
       private void btnNext_Click(object sender, EventArgs e)
       {
           index++;
           index = index > last? last : index;
           PopulateData();
       }

       private void PopulateData()
       {
           DataRow row = dt.Rows[index];
           string firstName = row["FirstName"].ToString();
           string lastName = row["LastName"].ToString();
           txtFirstName.Text = firstName;
           txtLastName.Text = lastName;

       }
   }

Gerry Schmitz · Answer 2 · 2022-07-07T15:19:00

Solution 7

Quote:
The advent of the BindingNavigator control in Windows Forms enables developers to provide end users with a simple data navigation and manipulation user interface on the forms they create.

Navigate Data with BindingNavigator Control - Windows Forms .NET Framework | Microsoft Docs[^]

Posted 7-Jul-22 15:19pm

Gerry Schmitz

Comments

[no name] 22-Mar-24 1:26am

how to add pervious button and show gride view

OriginalGriff · Answer 3 · 2016-06-22T21:51:00

You don't use a loop.
Exactly how to do this depends on a number of factors, such as how you are fetching your data, how much data is involved, and what exactly your DB contains.
But one way would be:
Make sure your DB contains an Id column, with is IDENTITY.
Set up a class level int in your DB called lastRow and set it to -1.
When you fetch a single row from the DB to display, use something like:

SQL

SELECT TOP 1 * FROM MyTable WHERE Id > lastRow ORDER BY ID ASC

If you get any rows, load lastRow with the ID value.
For "Next" it's the same query.
For previous its:

SQL

SELECT TOP 1 * FROM MyTable WHERE Id < lastRow ORDER BY ID DESC

First:

SQL

SELECT TOP 1 * FROM MyTable ORDER BY ID ASC

Lst:

SQL

SELECT TOP 1 * FROM MyTable ORDER BY ID DESC

Code for first next last previous button and display data in page windows C# application

3 solutions

Solution 2

Solution 7

Solution 1

Add your solution here

Preview 0