求一个Access数据库分页!坐等!!!QQ398229223!!!! 求一个Access数据库分页!坐等!!!QQ398229223!!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这个貌似只看见Sql的,我要Access的数据库分页。 /// <summary> /// 绑定Repeater /// </summary> /// <param name="repobj">Repeater对象</param> /// <param name="aspnetpager">分页对象</param> /// <param name="pager">分页条件对象</param> /// <param name="sqltype">Sql</param> /// <param name="pagesize">分页数</param> public static void BindObj(Repeater repobj, Wuqi.Webdiyer.AspNetPager aspnetpager, T_angel.Model.Common.PagerCondition pager, String sqltype, int pagesize) { T_angel.BLL.InfoBLL infobll = new T_angel.BLL.InfoBLL(); pager.ComplexSearchCondition = " and NType='" + sqltype + "'"; pager.PageSize = pagesize; pager.CurrentPage = aspnetpager.CurrentPageIndex; aspnetpager.PageSize = pagesize; if (string.IsNullOrEmpty(pager.SortDirection)) pager.SortDirection = "desc"; if (string.IsNullOrEmpty(pager.SortExpression)) pager.SortExpression = " NOrderNum asc,NRecommend asc,NAddTime"; IList<T_angel.Model.Entity.InfoEntity> infolist = infobll.GetInfoList(pager); repobj.DataSource = infolist; repobj.DataBind(); aspnetpager.RecordCount = pager.RecordCount; } pageSize 每页显示多少条数据 pageNumber 页数 pages=pageSize*(pageNumber-1)+1; SQL语句 string sql="select top "+pageSize+" * from 表名 where id>=(select max(id) from (select top "+pages+" id from 表名 order by id asc ) t )" 高手。。。请进 问几个关于程序性能的小问题 最简单的绑定方法??大牛们速来?? asp.net网站如何访问并显示另一台机器上的共享图片文件夹。~急急急急急急急急急急急 VS2005可不可以声明控件啊,如果有在哪里啊? (急,高分) web服务器启动不了怎么办? 错误: 非法赋值: 'i',大家看看,非常急,谢谢. 呵呵,收到源码,效率真高啊 请教各位大神正则表达式问题~ ====如何统一格式化DataGrid控件的外观==== 求sql语句,高手来下 两个用户自定义控件的交互操作
/// 绑定Repeater
/// </summary>
/// <param name="repobj">Repeater对象</param>
/// <param name="aspnetpager">分页对象</param>
/// <param name="pager">分页条件对象</param>
/// <param name="sqltype">Sql</param>
/// <param name="pagesize">分页数</param>
public static void BindObj(Repeater repobj, Wuqi.Webdiyer.AspNetPager aspnetpager, T_angel.Model.Common.PagerCondition pager, String sqltype, int pagesize)
{
T_angel.BLL.InfoBLL infobll = new T_angel.BLL.InfoBLL();
pager.ComplexSearchCondition = " and NType='" + sqltype + "'";
pager.PageSize = pagesize;
pager.CurrentPage = aspnetpager.CurrentPageIndex;
aspnetpager.PageSize = pagesize;
if (string.IsNullOrEmpty(pager.SortDirection))
pager.SortDirection = "desc";
if (string.IsNullOrEmpty(pager.SortExpression))
pager.SortExpression = " NOrderNum asc,NRecommend asc,NAddTime"; IList<T_angel.Model.Entity.InfoEntity> infolist = infobll.GetInfoList(pager); repobj.DataSource = infolist;
repobj.DataBind();
aspnetpager.RecordCount = pager.RecordCount;
}
pageNumber 页数
pages=pageSize*(pageNumber-1)+1;
SQL语句
string sql="select top "+pageSize+" * from 表名 where id>=(select max(id) from (select top "+pages+" id from 表名 order by id asc ) t )"