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

Posted on: 8/25/2009 6:01:05 PM by Syedshakeer | Views: 1209 | Category: Windows Forms | Level: Intermediate | Print Article

In this article you will know how to display records in a textboxes as First,Next,Previous and Last records

.NET Training Videos!
Buy online comprehensive training video pack just for $35.00 only, see what's inside it.

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

If you like this article, subscribe to our

RSS Feed. You can also subscribe via email to our Interview Questions, Codes and Forums section.

Interesting?

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

About Syed Shakeer Hussiain P