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

///

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

///

/// 查询条件

/// 第几页

/// 每页个数

/// 结果集

public static DataSet GetDataSetBySqlWhere(string sqlwhere, int page, int pagesize, string tablename)

{

string strSql = "SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM " + tablename;

if (sqlwhere != "")

strSql += " where " + sqlwhere;

strSql += ") A WHERE ROWNUM <= " + pagesize * page + " )WHERE RN >= " + ((page - 1) * pagesize + 1);

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

}

///

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

///

/// 条件

/// 总个数

public static int GetCountBySqlWhere(string sqlwhere, string tablename)

{

string strSql = "select count(*) from " + tablename;

if (sqlwhere != "")

strSql += " where " + sqlwhere;

object obj = DbHelperOra.GetSingle(strSql);

if (obj != null)

return Convert.ToInt32(obj);

else

return 0;

}