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

Syedshakeer
Posted by in Windows Forms category on for Intermediate level | Views : 12758 red flag

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

 

Page copy protected against web site content infringement by Copyscape

About the Author

Syedshakeer
Full Name: Syed Shakeer Hussiain P
Member Level:
Member Status: Member
Member Since: 2/5/2009 3:12:18 AM
Country: India
Syed Shakeer Hussain
http://www.dotnetfunda.com
Shakeer Hussain has completed his Master of Computer Applications degree from Deccan College of engg and technology of Osmania University.He is a MVM of www.dotnetspider.com.He has good experience in the areas of ASP.NET, C#.NET, VB.NET, SQL SERVER 2000/2005 and Windows Mobile. He has worked in Windows Mobile,Web Applicatin and ERP projects.

Login to vote for this post.

Comments or Responses

Login to post response

Comment using Facebook(Author doesn't get notification)