asp.net+oracle自己写的oracle分页语句（repeater+aspnetpage配合DbHelperOra）

  ///

        /// 根据条件分页查询结果
        ///

        /// 查询条件
        /// 第几页
        /// 每页个数
        /// 结果集
        public static DataSet GetDataSetBySqlWhere(string sqlwhere, int page, int pagesize, string tablename)
        {

            string strSql &＃61; "SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM " &＃43; tablename;
            if (sqlwhere !&＃61; "")
                strSql &＃43;&＃61; " where " &＃43; sqlwhere;
            strSql &＃43;&＃61; ") A WHERE ROWNUM <&＃61; " &＃43; pagesize * page &＃43; " )WHERE RN >&＃61; " &＃43; ((page - 1) * pagesize &＃43; 1);

            return DbHelperOra.Query(strSql.ToString());
        }
        ///

        /// 根据条件查询总个数
        ///

        /// 条件
        /// 总个数
        public static int GetCountBySqlWhere(string sqlwhere, string tablename)
        {
            string strSql &＃61; "select count(*) from " &＃43; tablename;
            if (sqlwhere !&＃61; "")
                strSql &＃43;&＃61; " where " &＃43; sqlwhere;
            object obj &＃61; DbHelperOra.GetSingle(strSql);
            if (obj !&＃61; null)
                return Convert.ToInt32(obj);
            else
                return 0;

        }