C#DataGridView分页显示代码详解

//导入命名空间部分省略

        string connectionString = @"Data Source=ServerName;Database=DatabaseName;integrated security=true";

        #region 初始化分页显示的参数           static int rowsall = 0;//总行数             static int pageall = 0;//总页数        static int page = 0;//第几页        static int count = 20;//返回20行        static int start = 0;//从第start行开始返回        #endregion

        #region 建立数据库链接        /// <summary>        /// 建立数据库连接        /// </summary>        /// <returns>返回SqlConnection对象</returns>        public SqlConnection getcon()        {            SqlConnection myCon = new SqlConnection(connectionString);                        return myCon;        }

        #region 设置DataGridView分页显示的参数，和初次绑定        /// <summary>        /// 设置DataGridView分页显示的参数，和初次绑定        /// </summary>        /// <param name="sqlstr">设置查询的sql语句</param>        /// <param name="table">设置返回绑定的DataSet中的表的名称</param>        /// <param name="dgv">要绑定的DataGridView</param>                public void upPage(string sqlstr,string table,DataGridView dgv)        {            rowsall = dbexecute.getds(sqlstr, table).Tables[table].Rows.Count;//总行数            if (rowsall == 0)            {                //如果没有数据则将第一页、上一页、下一页、最后一页设置为不可用；并设置其他参数                toolStripButton2.Enabled = false;                toolStripButton3.Enabled = false;                toolStripButton4.Enabled = false;                toolStripButton5.Enabled = false;                page = 0;                pageall = 0;                rowsall = 0;                dgv.DataSource = null;                tslRowsall.Text = rowsall.ToString();                tslPageAll.Text = pageall.ToString();                tslPage.Text = page.ToString();                return;            }            if (rowsall > 0)//判断是否有内容            {                page = 1;//如果有内容，设置为第一页                start = 0;            }                        int yushu = rowsall % count;//是否存在余行            if (yushu == 0)//不存在余行时设置总页数            {                if (rowsall > 0 && rowsall <= count)                {                    pageall = 1;                }                else                {                    pageall = rowsall / count;                }            }            else//存在余行时设置总页数            {                pageall = rowsall / count + 1;            }            {//设置显示数据，                 tslRowsall.Text = rowsall.ToString();                tslPageAll.Text = pageall.ToString();                tslPage.Text = page.ToString();                if (pageall > 0)                { //设置跳转到第几页                                         tscbPage.Items.Clear();                    for (int i = 1; i <= pageall; i++)                        tscbPage.Items.Add(i);                }            }            selectsql = sqlstr; //设置sql语句            dgv.DataSource = gettb(selectsql ,start,count,"table")‘;//绑定DataGridView

        }        #endregion

        #region        /// <summary>        /// 分页返回DataTable        /// </summary>        /// <param name="sql">查询的sql语句</param>        /// <param name="i">从第i行开始返回</param>        /// <param name="j">共返回j行记录</param>        /// <param name="tablename">返回DataSet中的表明</param>        /// <returns>返回DataTable</returns>        public DataTable gettb(string sql, int start, int count, string tablename)        {            SqlConnection con = this.getcon();            DataSet myds = new DataSet();            SqlDataAdapter sda = new SqlDataAdapter(sql, con);

            sda.Fill(myds, start, count, tablename);            return myds.Tables[tablename];        }        #endregion

        /// 第一页        private void toolStripButton2_Click(object sender, EventArgs e)        {            if (pageall > 1)            {                start = 0;                page = 1;                tslPage.Text = page.ToString();                this.dataGridView1.DataSource = gettb(selectsql ,start,count,"table")‘;//绑定DataGridView            }        }

        // 上一页        private void toolStripButton3_Click(object sender, EventArgs e)        {            if (page >1)            {                                page--;                start -= 20;                                tslPage.Text = page.ToString();                 this.dataGridView1.DataSource = gettb(selectsql ,start,count,"table")‘;//绑定DataGridView            }      

        }

        /// 下一页        private void toolStripButton4_Click(object sender, EventArgs e)        {            if (page < pageall)            {                                page++;                start += 20;                                tslPage.Text = page.ToString();                this.dataGridView1.DataSource = gettb(selectsql ,start,count,"table")‘;//绑定DataGridView            }                           }

         //最后一页        private void toolStripButton5_Click(object sender, EventArgs e)        {            if (pageall > 0)            {                start = (pageall - 1) * count;                page = pageall;                tslPage.Text = page.ToString();                 this.dataGridView1.DataSource = gettb(selectsql ,start,count,"table")‘;//绑定DataGridView            }        }  

本文来自博客，转载请标明出处：http://blog.csdn.net/shenhaha001/archive/2008/04/20/2308319.aspx