如何实现ListView高效分页代码

                return list;
            }
            return null ;
        }

        public int GetTotalRowsCount() {
            string sqlstr = "select * from classes where cisdel = 0" ;
            return SqlHelper .ExecuteScalar(sqlstr);
        }

SqlHelper新增方法如下：

View Code

public static DataTable getPageListByPage( int rowIndex, int pageSize, out int rowCount, out int pageCount, bool isDel) {            DataTable dtcalss = new DataTable();
            rowCount = 0;
            pageCount = 0;
            using (SqlConnection sqlcon = new SqlConnection (Connstr)) {
                SqlDataAdapter sda = new SqlDataAdapter( "up_GetPageData2" , sqlcon);
                SqlParameter [] pars = {
                                      new SqlParameter ( "@LastRowIndex",rowIndex),
                                      new SqlParameter ( "@pgSize",pageSize),
                                        new SqlParameter ( "@rowCount",rowCount),
                                        new SqlParameter ( "@pgCount",pageCount),
                                        new SqlParameter ( "@isDel",isDel),
                                      };