HOW TO ADD PAGING IN DATAGRIDVIEW IN C#

marcel ethan

Total Post:105

Points:735
Posted by  marcel ethan
C# 
C#
 1088  View(s)
Ratings:
Rate this:
Hi Developers,

How add paging concept in datagridview using c#

Any help will be appreciateable.

  1. Sumit Kesarwani

    Post:378

    Points:2694
    Re: How to add paging in datagridview in C#

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

            }

        }

    }

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!