How to add paging in datagridview in C#

Total Post:104

Points:728
C# 
C#
 1359  View(s)
Ratings:
Rate this:
Hi Developers,

How add paging concept in datagridview using c#

Any help will be appreciateable.

  1. 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");
            }
        }
    }

      Modified On Mar-30-2018 04:18:18 AM

Answer