Reader Level:
Article

How to Display Records as First-Next-Previous-Last in a Textboxes Using Windows Application

By Syed Shakeer on Jun 01, 2010
In this article you will know how to display records in a textboxes as First,Next,Previous and Last records.

HTML clipboard

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.

image1.gif

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();
            }
        }

image2.gif

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();

        }

image3.gif

Last Button Image

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.
            }
        }

image4.gif

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


 

Syed Shakeer

Shakeer is Working as a Software Engineer.He is expertise in WPF,SqlServer 2005/2008,Windows Moblie,C# and actively participating in R&D on Windows Mobile Development.

COMMENT USING