使用AspNetPager分页显示只有一页
ang18 2008-10-21 10:20:42 最近使用AspNetPager来分页,显示的只有一页,纳闷,存储过程及基本代码如下:
CREATE procedure PagerOrders
(@pagesize int,
@pageindex int)
as
set nocount on
begin
declare @indextable table(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
insert into @indextable(nid) select orderid from orders order by orderid desc
select * from orders O,@indextable t where O.orderid=t.nid
and t.id between @PageLowerBound+1 and @PageUpperBound order by t.id
end
set nocount off
GO
==========================================================================
if (!IsPostBack)
{
AspNetPager1.RecordCount = OrdersBLL.GetOrderCount();
Bindorders();
}
public void Bindorders()
{
Repeater1.DataSource = OrdersBLL.GetPagedOrders(AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex);
Repeater1.DataBind();
}
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
Bindorders();
}
其中GetPagedOrders为返回泛型实例IList<Orders> GetPagedOrders(int pagesize, int pageindex)...
初次使用AspNetPager,很急,大家看看问题出现在哪里,先谢谢了...