How to create pagination in datagridview using c#

Question

Rajanikant Hawaldar · Answer

Or else try below using System; using System.Data; using System.Windows.Forms; using System.Data.SqlClient; using System.Drawing; namespace WindowsFormsApplication1 { public partial class Form1 : Form { SqlDataAdapter pagingAdapter; DataSet pagingDS; int scrollVal; // This defines how many more data sets there are to load int rowsPerPage = 10; // This defines the total number of rows to show public Form1() { InitializeComponent(); scrollVal = 0; } private void BtnShowresults_Click( object sender, EventArgs e) { string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True" ; string sql = "SELECT * FROM Authors" ; SqlConnection connection = new SqlConnection(connectionString); pagingAdapter = new SqlDataAdapter(sql, connection); pagingDS = new DataSet(); connection.Open(); //This part will get the total number of records from the query pagingAdapter.Fill(dataSetProjects); DataTable dataTable = pagingDS.Tables[0]; int rowCount = Convert.ToInt32(dataTable.Rows.Count); this .btnShowresults.Tag = rowCount; // We set it to the button tag pagingAdapter.Fill(pagingDS, scrollVal, rowsPerPage, "Authors_table" ); connection.Close(); dataGridView1.DataSource = pagingDS; dataGridView1.DataMember = "Authors_table" ; } private void btnPrevious_Click( object sender, EventArgs e) { if (scrollVal { scrollVal = 0; } else { scrollVal -= rowsPerPage; } pagingDS.Clear(); pagingAdapter.Fill(pagingDS, scrollVal, rowsPerPage, "authors_table" ); } private void BtnNext_Click( object sender, EventArgs e) { Button btnShowresults = (Button)pnSearch.Controls[ "btnShowresults" ]; int resCount = Convert.ToInt32(btnShowresults.Tag); if (scrollVal { scrollVal = rowsPerPage; } else { scrollVal = rowsPerPage; } pagingDS.Clear(); pagingAdapter.Fill(pagingDS, scrollVal, rowsPerPage, "authors_table" ); } } }

Rajanikant Hawaldar · Answer

Hello, Refer below sample code, Created using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; public class SuperGrid : DataGridView { public int PageSize { get { return _pageSize; } set { _pageSize = value; } } public int _pageSize = 10; BindingSource bs; //= new BindingSource(); BindingList tables; // = new BindingList (); public void SetPagedDataSource(DataTable dataTable, BindingNavigator bnav) { if (dataTable == null || bnav == null ) { return ; } DataTable dt = null ; bs = new BindingSource(); tables = new BindingList (); int counter = 1; foreach (DataRow dr in dataTable.Rows) { if (counter == 1) { dt = dataTable.Clone(); tables.Add(dt); } dt.Rows.Add(dr.ItemArray); if (PageSize { counter = 1; } } bnav.BindingSource = bs; bs.DataSource = tables; bs.PositionChanged += bs_PositionChanged; bs_PositionChanged(bs, EventArgs.Empty); } void bs_PositionChanged( object sender, EventArgs e) { try { this .DataSource = tables[bs.Position]; } catch (Exception ex) { MessageBox.Show(ex.Message); } } } Form1 Code: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.IO; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace DataGrid_Pagination { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load( object sender, EventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add( "Col1" ); dt.Columns.Add( "Col2" ); dt.Columns.Add( "Col3" ); dt.Columns.Add( "Col4" ); dt.Columns.Add( "Col5" ); dt.Columns.Add( "Col6" ); dt.Columns.Add( "Col7" ); string [] Lines = File.ReadAllLines( "ApplicationDocs.txt" ); foreach ( string line in Lines ) { string [] split = line.Split( '	' ); dt.Rows.Add( split[0].ToString(), split[1].ToString(), split[2].ToString(), split[3].ToString(), split[4].ToString(), split[5].ToString(), split[6].ToString() ); } superGrid1 .SetPagedDataSource(dt, bindingNavigator1); // set paging size superGrid1 .PageSize = 100; } } } Designer Code : namespace DataGrid_Pagination { partial class Form1 { /// /// Required designer variable. /// private System.ComponentModel.IContainer components = null ; /// /// Clean up any resources being used. /// /// true if managed resources should be disposed; otherwise, false. protected override void Dispose( bool disposing) { if (disposing && (components != null )) { components.Dispose(); } base .Dispose(disposing); } #region Windows Form Designer generated code /// /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// private void InitializeComponent() { this .components = new System.ComponentModel.Container(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager( typeof (Form1)); this .bindingNavigator1 = new System.Windows.Forms.BindingNavigator( this .components); this .bindingNavigatorMoveFirstItem = new System.Windows.Forms.ToolStripButton(); this .bindingNavigatorMovePreviousItem = new System.Windows.Forms.ToolStripButton(); this .bindingNavigatorSeparator = new System.Windows.Forms.ToolStripSeparator(); this .bindingNavigatorPositionItem = new System.Windows.Forms.ToolStripTextBox(); this .bindingNavigatorCountItem = new System.Windows.Forms.ToolStripLabel(); this .bindingNavigatorSeparator1 = new System.Windows.Forms.ToolStripSeparator(); this .bindingNavigatorMoveNextItem = new System.Windows.Forms.ToolStripButton(); this .bindingNavigatorMoveLastItem = new System.Windows.Forms.ToolStripButton(); this .bindingNavigatorSeparator2 = new System.Windows.Forms.ToolStripSeparator(); this .bindingNavigatorAddNewItem = new System.Windows.Forms.ToolStripButton(); this .bindingNavigatorDeleteItem = new System.Windows.Forms.ToolStripButton(); this .superGrid1 = new SuperGrid(); ((System.ComponentModel.ISupportInitialize)( this .bindingNavigator1)).BeginInit(); this .bindingNavigator1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)( this .superGrid1)).BeginInit(); this .SuspendLayout(); // // bindingNavigator1 // this .bindingNavigator1.AddNewItem = this .bindingNavigatorAddNewItem; this .bindingNavigator1.CountItem = this .bindingNavigatorCountItem; this .bindingNavigator1.DeleteItem = this .bindingNavigatorDeleteItem; this .bindingNavigator1.Items.AddRange( new System.Windows.Forms.ToolStripItem[] { this .bindingNavigatorMoveFirstItem, this .bindingNavigatorMovePreviousItem, this .bindingNavigatorSeparator, this .bindingNavigatorPositionItem, this .bindingNavigatorCountItem, this .bindingNavigatorSeparator1, this .bindingNavigatorMoveNextItem, this .bindingNavigatorMoveLastItem, this .bindingNavigatorSeparator2, this .bindingNavigatorAddNewItem, this .bindingNavigatorDeleteItem}); this .bindingNavigator1.Location = new System.Drawing.Point(0, 0); this .bindingNavigator1.MoveFirstItem = this .bindingNavigatorMoveFirstItem; this .bindingNavigator1.MoveLastItem = this .bindingNavigatorMoveLastItem; this .bindingNavigator1.MoveNextItem = this .bindingNavigatorMoveNextItem; this .bindingNavigator1.MovePreviousItem = this .bindingNavigatorMovePreviousItem; this .bindingNavigator1.Name = "bindingNavigator1" ; this .bindingNavigator1.PositionItem = this .bindingNavigatorPositionItem; this .bindingNavigator1.Size = new System.Drawing.Size(868, 25); this .bindingNavigator1.TabIndex = 1; this .bindingNavigator1.Text = "bindingNavigator1" ; // // bindingNavigatorMoveFirstItem // this .bindingNavigatorMoveFirstItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image; this .bindingNavigatorMoveFirstItem.Image = ((System.Drawing.Image)(resources.GetObject( "bindingNavigatorMoveFirstItem.Image" ))); this .bindingNavigatorMoveFirstItem.Name = "bindingNavigatorMoveFirstItem" ; this .bindingNavigatorMoveFirstItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMoveFirstItem.Size = new System.Drawing.Size(23, 22); this .bindingNavigatorMoveFirstItem.Text = "Move first" ; // // bindingNavigatorMovePreviousItem // this .bindingNavigatorMovePreviousItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image; this .bindingNavigatorMovePreviousItem.Image = ((System.Drawing.Image)(resources.GetObject( "bindingNavigatorMovePreviousItem.Image" ))); this .bindingNavigatorMovePreviousItem.Name = "bindingNavigatorMovePreviousItem" ; this .bindingNavigatorMovePreviousItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMovePreviousItem.Size = new System.Drawing.Size(23, 22); this .bindingNavigatorMovePreviousItem.Text = "Move previous" ; // // bindingNavigatorSeparator // this .bindingNavigatorSeparator.Name = "bindingNavigatorSeparator" ; this .bindingNavigatorSeparator.Size = new System.Drawing.Size(6, 25); // // bindingNavigatorPositionItem // this .bindingNavigatorPositionItem.AccessibleName = "Position" ; this .bindingNavigatorPositionItem.AutoSize = false ; this .bindingNavigatorPositionItem.Name = "bindingNavigatorPositionItem" ; this .bindingNavigatorPositionItem.Size = new System.Drawing.Size(50, 23); this .bindingNavigatorPositionItem.Text = "0" ; this .bindingNavigatorPositionItem.ToolTipText = "Current position" ; // // bindingNavigatorCountItem // this .bindingNavigatorCountItem.Name = "bindingNavigatorCountItem" ; this .bindingNavigatorCountItem.Size = new System.Drawing.Size(35, 22); this .bindingNavigatorCountItem.Text = "of {0}" ; this .bindingNavigatorCountItem.ToolTipText = "Total number of items" ; // // bindingNavigatorSeparator1 // this .bindingNavigatorSeparator1.Name = "bindingNavigatorSeparator" ; this .bindingNavigatorSeparator1.Size = new System.Drawing.Size(6, 25); // // bindingNavigatorMoveNextItem // this .bindingNavigatorMoveNextItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image; this .bindingNavigatorMoveNextItem.Image = ((System.Drawing.Image)(resources.GetObject( "bindingNavigatorMoveNextItem.Image" ))); this .bindingNavigatorMoveNextItem.Name = "bindingNavigatorMoveNextItem" ; this .bindingNavigatorMoveNextItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMoveNextItem.Size = new System.Drawing.Size(23, 22); this .bindingNavigatorMoveNextItem.Text = "Move next" ; // // bindingNavigatorMoveLastItem // this .bindingNavigatorMoveLastItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image; this .bindingNavigatorMoveLastItem.Image = ((System.Drawing.Image)(resources.GetObject( "bindingNavigatorMoveLastItem.Image" ))); this .bindingNavigatorMoveLastItem.Name = "bindingNavigatorMoveLastItem" ; this .bindingNavigatorMoveLastItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMoveLastItem.Size = new System.Drawing.Size(23, 22); this .bindingNavigatorMoveLastItem.Text = "Move last" ; // // bindingNavigatorSeparator2 // this .bindingNavigatorSeparator2.Name = "bindingNavigatorSeparator" ; this .bindingNavigatorSeparator2.Size = new System.Drawing.Size(6, 25); // // bindingNavigatorAddNewItem // this .bindingNavigatorAddNewItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image; this .bindingNavigatorAddNewItem.Image = ((System.Drawing.Image)(resources.GetObject( "bindingNavigatorAddNewItem.Image" ))); this .bindingNavigatorAddNewItem.Name = "bindingNavigatorAddNewItem" ; this .bindingNavigatorAddNewItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorAddNewItem.Size = new System.Drawing.Size(23, 22); this .bindingNavigatorAddNewItem.Text = "Add new" ; // // bindingNavigatorDeleteItem // this .bindingNavigatorDeleteItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image; this .bindingNavigatorDeleteItem.Image = ((System.Drawing.Image)(resources.GetObject( "bindingNavigatorDeleteItem.Image" ))); this .bindingNavigatorDeleteItem.Name = "bindingNavigatorDeleteItem" ; this .bindingNavigatorDeleteItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorDeleteItem.Size = new System.Drawing.Size(23, 22); this .bindingNavigatorDeleteItem.Text = "Delete" ; // // superGrid1 // this .superGrid1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this .superGrid1.Dock = System.Windows.Forms.DockStyle.Fill; this .superGrid1.Location = new System.Drawing.Point(0, 0); this .superGrid1.Name = "superGrid1" ; this .superGrid1.PageSize = 100; this .superGrid1.Size = new System.Drawing.Size(868, 507); this .superGrid1.TabIndex = 0; // // Form1 // this .AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this .AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this .ClientSize = new System.Drawing.Size(868, 507); this .Controls.Add( this .bindingNavigator1); this .Controls.Add( this .superGrid1); this .Name = "Form1" ; this .Text = "Form1" ; this .Load += new System.EventHandler( this .Form1_Load); ((System.ComponentModel.ISupportInitialize)( this .bindingNavigator1)).EndInit(); this .bindingNavigator1.ResumeLayout( false ); this .bindingNavigator1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)( this .superGrid1)).EndInit(); this .ResumeLayout( false ); this .PerformLayout(); } #endregion private SuperGrid superGrid1; private System.Windows.Forms.BindingNavigator bindingNavigator1; private System.Windows.Forms.ToolStripButton bindingNavigatorAddNewItem; private System.Windows.Forms.ToolStripLabel bindingNavigatorCountItem; private System.Windows.Forms.ToolStripButton bindingNavigatorDeleteItem; private System.Windows.Forms.ToolStripButton bindingNavigatorMoveFirstItem; private System.Windows.Forms.ToolStripButton bindingNavigatorMovePreviousItem; private System.Windows.Forms.ToolStripSeparator bindingNavigatorSeparator; private System.Windows.Forms.ToolStripTextBox bindingNavigatorPositionItem; private System.Windows.Forms.ToolStripSeparator bindingNavigatorSeparator1; private System.Windows.Forms.ToolStripButton bindingNavigatorMoveNextItem; private System.Windows.Forms.ToolStripButton bindingNavigatorMoveLastItem; private System.Windows.Forms.ToolStripSeparator bindingNavigatorSeparator2; } }

Jignesh Kumar · Answer

Hi Raghu, Please use this link which will help you, https://www.aspsnippets.com/Articles/Implement-Paging-DataGridView-in-Windows-Forms-WinForms-Application-using-C-and-VBNet.aspx