aspnetpager分页控件源码
来源:互联网 发布:powerdesigner 软件 编辑:程序博客网 时间:2024/05/02 03:06
自定义设置格式化代码:
<webdiyer:AspNetPager id="AspNetPagerView" runat="server" SubmitButtonText="转到" ShowPageIndex="False"
ShowInputBox="Always" LastPageText="<font style='FONT-SIZE: x-small'>最后页</fornt>" NextPageText="<font style='FONT-SIZE: x-small'>下一页</fornt>"
PrevPageText="<font style='FONT-SIZE: x-small'>前一页</fornt>" FirstPageText="<font style='FONT-SIZE: x-small'>最前页</fornt>"
InputBoxStyle="border:1px #0000FF solid;text-align:center;FONT-SIZE: x-small" TextBeforeInputBox="第"
TextAfterInputBox="页" ShowCustomInfoSection="Right" AlwaysShow="True" CustomInfoTextAlign="Center"
SubmitButtonStyle="width:40px;height:21px;"></webdiyer:AspNetPager>
后台使用代码:
private void Page_Load(object sender, System.EventArgs e)
...{
if(!Page.IsPostBack)
...{
this.sqlCmd=new System.Data.SqlClient.SqlCommand("SP_AspNetPager_Meeting",this.sqlConn);
this.sqlCmd.CommandType=CommandType.StoredProcedure;
this.sqlCmd.Parameters.Add("@pageindex",1);
this.sqlCmd.Parameters.Add("@pagesize",1);
this.sqlCmd.Parameters.Add("@docount",true);
this.sqlConn.Open();
this.AspNetPagerView.RecordCount=(int)this.sqlCmd.ExecuteScalar();
this.sqlConn.Close();
this.SetBindData();
}
}
private void SetBindData()
...{
this.sqlCmd=new SqlCommand("SP_AspNetPager_Meeting",this.sqlConn);
this.sqlCmd.CommandType=CommandType.StoredProcedure;
this.sqlCmd.Parameters.Add("@pageindex",this.AspNetPagerView.CurrentPageIndex);
this.sqlCmd.Parameters.Add("@pagesize",this.AspNetPagerView.PageSize);
this.sqlCmd.Parameters.Add("@docount",false);
this.sqlConn.Open();
this.dg.DataSource=this.sqlCmd.ExecuteReader();
this.dg.DataBind();
this.sqlConn.Close();
this.AspNetPagerView.CustomInfoText=" 当前页:<font color="red"><b>"+this.AspNetPagerView.CurrentPageIndex.ToString()+"</b></font>";
this.AspNetPagerView.CustomInfoText+=" 总页数:<font color="blue"><b>"+this.AspNetPagerView.PageCount.ToString()+"</b></font>";
this.AspNetPagerView.CustomInfoText+=" 记录总数:<font color="blue"><b>"+this.AspNetPagerView.RecordCount.ToString()+"</b></font>";
}
private void AspNetPagerView_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
...{
this.AspNetPagerView.CurrentPageIndex=e.NewPageIndex;
this.SetBindData();
System.Text.StringBuilder sb=new System.Text.StringBuilder("<script Language="Javascript"><!-- ");
sb.Append("var el=document.all;");
sb.Append(dg.ClientID);
sb.Append(".scrollIntoView(true);");
sb.Append("<");
sb.Append("/");
sb.Append("script>");
if(!Page.IsStartupScriptRegistered("scrollScript"))
Page.RegisterStartupScript("scrollScript",sb.ToString());
}
存储过程:
CREATE procedure SP_AspNetPager_Meeting
(@pagesize int,
@pageindex int,
@docount bit)
as
set nocount on
if(@docount=1)
select count(id) from Meeting
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 Meeting order by id asc
select O.* from Meeting 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
<webdiyer:AspNetPager id="AspNetPagerView" runat="server" SubmitButtonText="转到" ShowPageIndex="False"
ShowInputBox="Always" LastPageText="<font style='FONT-SIZE: x-small'>最后页</fornt>" NextPageText="<font style='FONT-SIZE: x-small'>下一页</fornt>"
PrevPageText="<font style='FONT-SIZE: x-small'>前一页</fornt>" FirstPageText="<font style='FONT-SIZE: x-small'>最前页</fornt>"
InputBoxStyle="border:1px #0000FF solid;text-align:center;FONT-SIZE: x-small" TextBeforeInputBox="第"
TextAfterInputBox="页" ShowCustomInfoSection="Right" AlwaysShow="True" CustomInfoTextAlign="Center"
SubmitButtonStyle="width:40px;height:21px;"></webdiyer:AspNetPager>
后台使用代码:
private void Page_Load(object sender, System.EventArgs e)
...{
if(!Page.IsPostBack)
...{
this.sqlCmd=new System.Data.SqlClient.SqlCommand("SP_AspNetPager_Meeting",this.sqlConn);
this.sqlCmd.CommandType=CommandType.StoredProcedure;
this.sqlCmd.Parameters.Add("@pageindex",1);
this.sqlCmd.Parameters.Add("@pagesize",1);
this.sqlCmd.Parameters.Add("@docount",true);
this.sqlConn.Open();
this.AspNetPagerView.RecordCount=(int)this.sqlCmd.ExecuteScalar();
this.sqlConn.Close();
this.SetBindData();
}
}
private void SetBindData()
...{
this.sqlCmd=new SqlCommand("SP_AspNetPager_Meeting",this.sqlConn);
this.sqlCmd.CommandType=CommandType.StoredProcedure;
this.sqlCmd.Parameters.Add("@pageindex",this.AspNetPagerView.CurrentPageIndex);
this.sqlCmd.Parameters.Add("@pagesize",this.AspNetPagerView.PageSize);
this.sqlCmd.Parameters.Add("@docount",false);
this.sqlConn.Open();
this.dg.DataSource=this.sqlCmd.ExecuteReader();
this.dg.DataBind();
this.sqlConn.Close();
this.AspNetPagerView.CustomInfoText=" 当前页:<font color="red"><b>"+this.AspNetPagerView.CurrentPageIndex.ToString()+"</b></font>";
this.AspNetPagerView.CustomInfoText+=" 总页数:<font color="blue"><b>"+this.AspNetPagerView.PageCount.ToString()+"</b></font>";
this.AspNetPagerView.CustomInfoText+=" 记录总数:<font color="blue"><b>"+this.AspNetPagerView.RecordCount.ToString()+"</b></font>";
}
private void AspNetPagerView_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
...{
this.AspNetPagerView.CurrentPageIndex=e.NewPageIndex;
this.SetBindData();
System.Text.StringBuilder sb=new System.Text.StringBuilder("<script Language="Javascript"><!-- ");
sb.Append("var el=document.all;");
sb.Append(dg.ClientID);
sb.Append(".scrollIntoView(true);");
sb.Append("<");
sb.Append("/");
sb.Append("script>");
if(!Page.IsStartupScriptRegistered("scrollScript"))
Page.RegisterStartupScript("scrollScript",sb.ToString());
}
存储过程:
CREATE procedure SP_AspNetPager_Meeting
(@pagesize int,
@pageindex int,
@docount bit)
as
set nocount on
if(@docount=1)
select count(id) from Meeting
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 Meeting order by id asc
select O.* from Meeting 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
- aspnetpager分页控件源码
- AspNetPager分页控件
- AspNetPager分页控件
- AspNetPager分页控件
- AspNetPager分页控件
- AspNetPager分页控件
- AspNetPager分页控件
- AspNetPager分页控件
- AspNetPager分页控件
- aspnetpager.dll分页控件
- AspNetPager分页控件 最新动态
- AspNetPager分页控件
- AspNetPager分页控件--使用方法
- AspNetPager分页控件使用方法
- AspNetPager分页控件
- AspNetPager分页控件
- AspNetPager控件分页使用方法
- AspNetPager分页控件使用
- ASP.NET开发栈
- 开发人员常犯的8个错误
- JDBC事务隔离级别
- 气愤ING
- 一些tomcat数据库连接的配置的汇总
- aspnetpager分页控件源码
- ruby字符转码(包括不限于中文)
- Top Ten Errors Java Programmers Make
- 走好改革路
- 追MM与设计模式(Factory代码)
- 洗牌算法分析(一)
- 用fatJar将SWT/JFace工程打成双击可执行Jar包
- CString类所有成员函数详解
- 洗牌程序分析(二)