C#DataGridView分页显示代码详解

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

DBClass.DBExecute dbexecute = new DBExecute();       

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;

                p