AspNetPager(陕北吴旗娃)分页控件问题
private void Page_Load(object sender, System.EventArgs e)
{
conn=new SqlConnection(ConfigurationSettings.AppSettings["StrCon"]);
if(!Page.IsPostBack)
{
cmd=new SqlCommand("Hbzc_NetPager",conn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("@pageindex",1);
cmd.Parameters.Add("@pagesize",1);
cmd.Parameters.Add("@docount",true);
conn.Open();
pager.RecordCount=(int)cmd.ExecuteScalar();
conn.Close();
BindData();
}
}
public void BindData()
{
cmd=new SqlCommand("Hbzc_NetPager",conn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("@pageindex",pager.CurrentPageIndex);
cmd.Parameters.Add("@pagesize",pager.PageSize);
cmd.Parameters.Add("@docount",false);
conn.Open();
DataList1.DataSource=cmd.ExecuteReader();
DataList1.DataBind();
conn.Close();
}
public void ChangePage(object src,Wuqi.Webdiyer.PageChangedEventArgs e)
{
pager.CurrentPageIndex=e.NewPageIndex;
BindData();
}
存储过程:
CREATE procedure Hbzc_NetPager
(@pagesize int,
@pageindex int,
@docount bit)
as
set nocount on
if(@docount=1)
select count(*) from Article
else
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 id from Article order by updatetime desc
select O.title,O.updatetime,O.url from Article O,@indextable t where O.id=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
end
set nocount off
GO
总是无法显示内容
帮帮忙