C#通用分页

代码

// An highlighted block
        /// <summary>
        /// 获取分页数据
        /// </summary>
        /// <param name="Constring">数据库连接字符串</param>
        /// <param name="SqlData">要查询的语句</param>
        /// <param name="sqlwhere">语句条件</param>
        /// <param name="orderBy">排序字段</param>
        /// <param name="pageIndex">当前页码</param>
        /// <param name="pageSize">一页多少条</param>
        /// <returns></returns>
        public DataTable GetPaginData(string Constring, string SqlData, string sqlwhere, string orderBy, int pageIndex, int pageSize)
        {
   
            string sqlFormat = @"select *
                                from (select *,COUNT(1) OVER() AS TotalCount,ROW_NUMBER() over