Paging in DataGridview Using C#.Net In Windows Application

In my previous article I have show you How to Bind xml to DataGridView Using C#.Net In Windows Application and Bind And Display Image in a DatagridView Using C#.Net in Windows Application. Now in this article I will show you how you can bind a datageidview control and perform paging operation in for the record in datagridview by using datatable, access database. You can use SQL databse to bind the data.

Some of my previous articles are as follows: Bind DataGridView In Windows Application Using C#, How To Make a Single Row of DataGridview Bold Using C#.Net in Windows Application, GridView With Fixed Headers in Asp.Net Using C# and jQuery, How to Bind Data To TextBox Values in Asp.Net GridView Control Using C#.Net, Bind And Display Image in a DatagridView Using C#.Net in Windows Application, How to Bind xml to DataGridView Using C#.Net In Windows Application.

So for this article first we will create a new windows application and add a datagridview control and two button control for displaying paging functionality.

Now we will create table and add some record in it.

Now we will first write code to bind the gridview control.

public string connectionstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=bookstore.mdb;Persist Security Info=False;";         DataTable _objdt;         OleDbDataAdapter _objda;         public Form1()         {             InitializeComponent();         }         private void Form1_Load(object sender, EventArgs e)         {             BindData();         }         public void BindData()         {             _objdt = new DataTable();             DataTable _objtotalRecord = new DataTable();             string querystring = "select Name,Address,Marks from Student;";             OleDbConnection _objcon = new OleDbConnection(connectionstring);             _objda = new OleDbDataAdapter(querystring, _objcon);             _objcon.Open();             //for filling the grid             _objda.Fill(minValue, maxValue, _objdt);             dataGridView1.DataSource = _objdt;         }

Now we will write code on next and previous button click.

Code for NEXT button

private void button2_Click(object sender, EventArgs e)         {             int nextCount = minValue + _objdt.Rows.Count;             _objdt = new DataTable();             _objda.Fill(nextCount, maxValue, _objdt);             dataGridView1.DataSource = _objdt;             minValue = nextCount;             //Enable disable button             if (_objdt.Rows.Count == maxValue)             {                 button1.Enabled = true;                 button2.Enabled = true;             }             else             {                 button1.Enabled = true;                 button2.Enabled = false;                 minValue = nextCount + _objdt.Rows.Count;             }         }

In above code first I have check the index of current record and as per value I have made button enable disable.

Code for PREVIOUS button

private void button1_Click(object sender, EventArgs e)         {             int nextCount = (minValue - (_objdt.Rows.Count + maxValue)) < maxValue ? 0 : (minValue - (_objdt.Rows.Count + maxValue));             _objdt = new DataTable();             _objda.Fill(nextCount, maxValue, _objdt);             dataGridView1.DataSource = _objdt;             minValue = nextCount;             //Enable disable button             if (minValue == 0)             {                 button1.Enabled = false;                 button2.Enabled = true;             }             else             {                 button1.Enabled = true;                 button2.Enabled = true;             }         }

In above code I have checked weather the final value in less the 0 or not if it’s less than 0 then make the button enable disable as per value, and pass the starting count of value to the adapter.

Now we will check the complete code of the form

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using Microsoft.VisualBasic.FileIO; using System.Data.OleDb; namespace WindowsFormsApplication7 {     public partial class Form1 : Form     {         public string connectionstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=bookstore.mdb;Persist Security Info=False;";         DataTable _objdt;         int minValue = 0;         int maxValue = 3;         OleDbDataAdapter _objda;         public Form1()         {             InitializeComponent();         }         private void Form1_Load(object sender, EventArgs e)         {             BindData();         }         public void BindData()         {             _objdt = new DataTable();             DataTable _objtotalRecord = new DataTable();             string querystring = "select Name,Address,Marks from Student;";             OleDbConnection _objcon = new OleDbConnection(connectionstring);             _objda = new OleDbDataAdapter(querystring, _objcon);             _objcon.Open();             //for filling the grid             _objda.Fill(minValue, maxValue, _objdt);             dataGridView1.DataSource = _objdt;         }         private void button2_Click(object sender, EventArgs e)         {             int nextCount = minValue + _objdt.Rows.Count;             _objdt = new DataTable();             _objda.Fill(nextCount, maxValue, _objdt);             dataGridView1.DataSource = _objdt;             minValue = nextCount;             //Enable disable button             if (_objdt.Rows.Count == maxValue)             {                 button1.Enabled = true;                 button2.Enabled = true;             }             else             {                 button1.Enabled = true;                 button2.Enabled = false;                 minValue = nextCount + _objdt.Rows.Count;             }         }         private void button1_Click(object sender, EventArgs e)         {             int nextCount = (minValue - (_objdt.Rows.Count + maxValue)) < maxValue ? 0 : (minValue - (_objdt.Rows.Count + maxValue));             _objdt = new DataTable();             _objda.Fill(nextCount, maxValue, _objdt);             dataGridView1.DataSource = _objdt;             minValue = nextCount;             //Enable disable button             if (minValue == 0)             {                 button1.Enabled = false;                 button2.Enabled = true;             }             else             {                 button1.Enabled = true;                 button2.Enabled = true;             }         }     } }

Now we have done run the application to check the final output.

DOWNLOAD