如何给list<T>分页,我的数据现在都在list<T>中, 用的是AspNetPager控件!
解决方案 »
- firefox下js取文本框值错误
- asp.net js+div 非IE浏览器弹出层在执行了后台程序消失的问题
- 如何让背景图片铺满整个<td></td>标签内部?
- // 以前vs 2003 这个地方有个命名空间说定义,现在怎么没了?我怎么知道这个类默认是哪个命名空间呢??
- 请教一个ASP.NET导出数据到EXCEL问题!
- ToString()格式化的问题
- 关于mvc的感想,大家帮忙解决下
- 从datagrid1中获得选中行的某个值
- html里的文字连接怎么触发事件啊???
- 关于DataReader读取字段值的问题
- xpath 精确定位父元素
- 用户控件里updatapanel导致整页面刷新了,无奈求解!
xxx.datasource=nlst;
估计OK了.
分页存储过程到list
{
int pageSize = 5;//页面内容数
int pageIndex = pageindex;//获取当前页数
AspNetPager1.PageSize = pageSize;//设置页面内容数
int outCounts;
string where = "StickyNoteTypeId =" + noteType;
showStickyNote(LiaojieDemoBLL.StickyNoteManager .GetAllStickyNote(pageSize, pageIndex, where, out outCounts)); AspNetPager1.RecordCount = outCounts;
} protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
noteType =Convert.ToInt32(Session["NoteType"]);
NetPager(AspNetPager1.CurrentPageIndex,noteType );
}
我用的是IList<model>
private void nDataBind()
{
int totalCount = 0;
string currentIndex;
currentIndex = Request.QueryString["page"];
string pageSize;
pageSize = AspNetPager.PageSize.ToString(); Sppaper customerlist = new Sppaper();
IList<RcustomerInfo> us = new List<RcustomerInfo>();
us = customerlist.getDataList("Rcustomer", "*", "idx", pageSize, currentIndex, "", out totalCount);
if (us.Count > 0)
{
Customermanage.DataSource = us;
Customermanage.DataBind();
}
}
PageSize 页大小
for(int i=(PageIndex-1)*PageSize;i<PageSize;i++)
{
ts.Add(dts[i]);
}写个思路
public int PageSize { get; private set; }
public int TotalCount { get; private set; }
public int TotalPages { get; private set; } public PaginatedList(IQueryable<T> source, int pageIndex, int pageSize) {
PageIndex = pageIndex;
PageSize = pageSize;
TotalCount = source.Count();
TotalPages = (int) Math.Ceiling(TotalCount / (double)PageSize); this.AddRange(source.Skip(PageIndex * PageSize).Take(PageSize));
} public bool HasPreviousPage {
get {
return (PageIndex > 0);
}
} public bool HasNextPage {
get {
return (PageIndex+1 < TotalPages);
}
}
}