.net分页查询方法

将此代码复制到一个类中：

　　  #region 分页查询
        /// <summary>
        /// 根基条件分页数据
        /// </summary>
        /// <param name="table">需要查询的表名称</param>
        /// <param name="pageindex1">页下标</param>
        /// <param name="pagesize">每页显示条数</param>
        /// <param name="ziduan">查询的字段</param>
        /// <param name="andstr">约束条件</param>
        /// <param name="orderstr">排序条件（例如：Top Desc,TuiJian Desc,LastTime Desc）</param>
        /// <returns></returns>
        public static DataSet FenYe(string table,int pageindex1, int pagesize, string ziduan, string andstr,string orderstr)
        {
            int page = ((pageindex1 - 1) * pagesize) + 1;
            StringBuilder sql = new StringBuilder();
            sql.Append("select " + ziduan + " from (select ROW_NUMBER() over(order By T." + orderstr + ") as Row,T." + ziduan + " from "+table+" T where 1=1 " + andstr + " ) TT where TT.Row between " + page + " and " + pageindex1 * pagesize + " order By "+orderstr);
            return SQLHelper.Query(sql.ToString());
        }
        #endregion

调用该方法，传入对应参数

 

转载于:https://www.cnblogs.com/yxlove/articles/3779417.html