How to display records as First-Next-Previous-Last in a Textboxes using Windows Application?

In this article you will know how to display records in a textboxes as First,Next,Previous and Last records.For doing this we have to add textboxes and 4 buttons on a Windows form.see below design of windows form containing buttons and textboxes.

Here i am using DataGridvew to show you records present in atable.Bind a Data to the DataGridview.Here i am using MsAccess DataProvider as Odbc client.You can use your own DataProvider in the same way.

Explanation:When the users clicks on 'First Button' ,the first record of a table have to display in a corresponding column textboxe.

Coding for 'First Button':- Double click on 'First Button' and write the below code.

private void btnfirst_Click(object sender, EventArgs e)
{
 if (ds.Tables[0].Rows.Count > 0)
 {
    i = 0;
    textBox1.Text = ds.Tables[0].Rows[i]["ID"].ToString();
    textBox2.Text = ds.Tables[0].Rows[i]["empname"].ToString();
   textBox3.Text = ds.Tables[0].Rows[i ]["salary"].ToString();
 }
}

First Button Image

Coding for 'Last Button':- Double click on'Last Button' and write the below code.

private void btnlast_Click(object sender, EventArgs e)
{
  i = ds.Tables[0].Rows.Count - 1;
  textBox1.Text = ds.Tables[0].Rows[i ]["ID"].ToString();
  textBox2.Text = ds.Tables[0].Rows[i]["empname"].ToString();
  textBox3.Text = ds.Tables[0].Rows[i]["salary"].ToString();
 
}

Last Button Iamge

Coding for 'Next Button':- Double click on'Next Button' and write the below code.

private void btnnext_Click(object sender, EventArgs e)
{
 
  if (i < ds.Tables[0].Rows.Count-1)
  {
    i++;
    textBox1.Text = ds.Tables[0].Rows[i]["ID"].ToString();
    textBox2.Text = ds.Tables[0].Rows[i]["empname"].ToString();
    textBox3.Text = ds.Tables[0].Rows[i]["salary"].ToString();
  }
  else
  {
    //no records to see more.
  }
}

 Next Button Image

Coding for 'Previous Button':- Double click on'Previous Button' and write the below code.

private void btnprevious_Click(object sender, EventArgs e)
{
  if (i == ds.Tables[0].Rows.Count - 1 || i !=0)
  {
    i--;
    textBox1.Text = ds.Tables[0].Rows[i]["ID"].ToString();
    textBox2.Text = ds.Tables[0].Rows[i]["empname"].ToString();
    textBox3.Text = ds.Tables[0].Rows[i]["salary"].ToString();
  }
   else
  {
       //No records to see more
  }
}

Above ds.Tables[0].Rows.Count means it counts number of records presnt in a table.

The Complete coding in Form1.cs as follows:-

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.Odbc;
using System.IO;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
   public Form1()
{
   InitializeComponent();
}
OdbcDataAdapter da;
DataSet ds;
int i = 0;
int j;
OdbcConnection conn;
int last;
private void Form1_Load(object sender, EventArgs e)
{
conn = new OdbcConnection("dsn=t1");
conn.Open();
da = new OdbcDataAdapter("select * from emp", conn);
OdbcCommandBuilder builder = new OdbcCommandBuilder(da);
ds = new DataSet();
da.Fill(ds, "emp");
dataGridView1.DataSource = ds.Tables["emp"];
}
 
private void btnfirst_Click(object sender, EventArgs e)
{
if (ds.Tables[0].Rows.Count > 0)
{
i = 0;
textBox1.Text = ds.Tables[0].Rows[i]["ID"].ToString();
textBox2.Text = ds.Tables[0].Rows[i]["empname"].ToString();
textBox3.Text = ds.Tables[0].Rows[i ]["salary"].ToString();
}
}
private void btnlast_Click(object sender, EventArgs e)
{
i = ds.Tables[0].Rows.Count - 1;
textBox1.Text = ds.Tables[0].Rows[i ]["ID"].ToString();
textBox2.Text = ds.Tables[0].Rows[i]["empname"].ToString();
textBox3.Text = ds.Tables[0].Rows[i]["salary"].ToString();
 
}
private void btnnext_Click(object sender, EventArgs e)
{
 
if (i < ds.Tables[0].Rows.Count-1)
{
i++;
textBox1.Text = ds.Tables[0].Rows[i]["ID"].ToString();
textBox2.Text = ds.Tables[0].Rows[i]["empname"].ToString();
textBox3.Text = ds.Tables[0].Rows[i]["salary"].ToString();
}
   else
{
}
}
private void btnprevious_Click(object sender, EventArgs e)
{
   if (i == ds.Tables[0].Rows.Count - 1 || i !=0)
{
   i--;
   textBox1.Text = ds.Tables[0].Rows[i]["ID"].ToString();
   textBox2.Text = ds.Tables[0].Rows[i]["empname"].ToString();
   textBox3.Text = ds.Tables[0].Rows[i]["salary"].ToString();
   }
      else
     {
      }
   }
 
}

Thanks for reading my article!

  Syed Shakeer Hussain