分页获取数据列表

/// <summary>
        /// 分页获取数据列表
        /// </summary>
        public DataSet GetList(int PageSize,int PageIndex,string strWhere)
        {
            SqlParameter[] parameters = {
                    new SqlParameter("@tblName", SqlDbType.VarChar, 255),//表明
                    new SqlParameter("@fldName", SqlDbType.VarChar, 255),//主键
                    new SqlParameter("@PageSize", SqlDbType.Int),
                    new SqlParameter("@PageIndex", SqlDbType.Int),
                    new SqlParameter("@IsReCount", SqlDbType.Bit),//返回记录总数, 非 0 值则返回
                    new SqlParameter("@OrderType", SqlDbType.Bit),//设置排序类型, 非 0 值则降序
                    new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
                    };
            parameters[0].Value = "tb_Expert";
            parameters[1].Value = "ExpertID";
            parameters[2].Value = PageSize;
            parameters[3].Value = PageIndex;
            parameters[4].Value = 0;
            parameters[5].Value = 0;
            parameters[6].Value = strWhere;    
            return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
        }

 

转载于:https://www.cnblogs.com/thinkingthigh/archive/2013/04/26/3044324.html