---
title: "How to add paging in datagridview in C#"  
description: "How to add paging in datagridview in C#"  
author: "marcel ethan"  
published: 2013-06-15  
updated: 2013-06-15  
canonical: https://www.mindstick.com/forum/1156/how-to-add-paging-in-datagridview-in-c-sharp  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# How to add paging in datagridview in C#

Hi [Developers](https://www.mindstick.com/articles/12875/blunders-you-must-avoid-while-hiring-java-developers-to-get-the-best-fulfilling-your-needs),

How [add](https://www.mindstick.com/forum/12983/add-address-in-textbox-when-page-is-load-and-if-i-search-address-in-textbox-show-in-map-by-javascript) [paging](https://www.mindstick.com/articles/335974/retrieve-data-from-restful-api-and-add-paging-in-knockout-js) [concept](https://www.mindstick.com/blog/79/routing-concept-in-dot-net) in [datagridview](https://www.mindstick.com/articles/607/working-with-datagridview-in-vc-sharp) using c#

Any help will be appreciateable.

## Replies

### Reply by Sumit Kesarwani

Hi Marcel,\
below I provide you some line of code in datagridview.

```
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;         public Form1()        {            InitializeComponent();            scrollVal = 0;        }         private void button1_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();            pagingAdapter.Fill(pagingDS, scrollVal, 5, "Authors_table");            connection.Close();            dataGridView1.DataSource = pagingDS;            dataGridView1.DataMember = "Authors_table";        }         private void button2_Click(object sender, EventArgs e)        {            scrollVal = scrollVal - 5;            if (scrollVal < = 0)            {                scrollVal = 0;            }            pagingDS.Clear();            pagingAdapter.Fill(pagingDS, scrollVal, 5, "authors_table");        }         private void button3_Click(object sender, EventArgs e)        {            scrollVal = scrollVal + 5;            if (scrollVal > 23)            {                scrollVal = 18;            }            pagingDS.Clear();            pagingAdapter.Fill(pagingDS, scrollVal, 5, "authors_table");        }    }}
```


---

Original Source: https://www.mindstick.com/forum/1156/how-to-add-paging-in-datagridview-in-c-sharp

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.