AspNetPager分页控件

最新推荐文章于 2022-02-25 20:00:37 发布

Cool_xiaocao

最新推荐文章于 2022-02-25 20:00:37 发布

阅读量132

点赞数

分类专栏： Asp.net 控件使用文章标签： SQL Go C C++ C#

本文链接：https://blog.csdn.net/Cool_xiaocao/article/details/83836802

版权

Asp.net 控件使用专栏收录该内容

5 篇文章 0 订阅

订阅专栏


<webdiyer:AspNetPager ID="AspNetPager1" runat="server" CustomInfoHTML="每页显示 <input type='text' style='width:30px;' readonly='true' value='%PageSize%' class='input_text' style='text-align:center'/> 条 当前 %CurrentPageIndex%/%PageCount% 页 共 %RecordCount% 条记录  "  ShowCustomInfoSection="Left" Width="500px" FirstPageText="首页" LastPageText="尾页" LayoutType="Table" NextPageText="下一页" PrevPageText="上一页" ShowPageIndex="False" CustomInfoTextAlign="Right" HorizontalAlign="Right" PageSize="5" SubmitButtonText="Go" CssClass="left_title_footer" PageIndexBoxClass="input_text1" PageIndexBoxType="TextBox" ShowPageIndexBox="Always" SubmitButtonClass="input_button" TextAfterPageIndexBox="&nbsp;页&nbsp;" TextBeforePageIndexBox="转到&nbsp;" PageIndexBoxStyle="text-align:center">
</webdiyer:AspNetPager>

[img]http://dl.iteye.com/upload/attachment/407628/4b259d21-b99a-3d68-b286-9e09934d886e.png[/img]


protected void Page_Load(object sender, EventArgs e)
    {
        //获取数据记录数
        AspNetPager1.RecordCount = GetPageCount;
    }

//PageChanged事件
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
    {
        DataBind();
    }


-- =============================================
-- Author:		DylanChan
-- Create date: 2010.12.21 21:23
-- Description:	获取表的记录数
-- =============================================
CREATE PROCEDURE [procGetCount]
@tableName varchar(50),
@condition varchar(1000)='1=1'
AS
BEGIN
declare @SQL varchar(1000)
set @SQL = 'select count(*) from [' + @tableName + '] where ' + @condition
print(@SQL)
exec(@SQL)
END

exec procGetCount '表名','条件'


-- =============================================
-- Author:		DylanChan
-- Create date: 2010.12.21 20:30
-- Description:	获取分页数据
-- =============================================
CREATE PROCEDURE [procGetPager]
@startIndex int,
@pageSize int,
@tableName varchar(50),
@condition varchar(1000)='1=1',
@primaryKey varchar(50),
@orderType varchar(20)
AS
BEGIN
declare @SQL varchar(1000)
set @SQL = 'select top ' + str(@pageSize) + ' * from [' + @tableName + '] where ' + @condition + ' and ' + @primaryKey + ' not in (select top ' + str(@startIndex) + ' ' + @primaryKey + ' from [' + @tableName + '] where ' + @condition + ' order by ' + @primaryKey + ' ' + @orderType + ') order by ' + @primaryKey + ' ' + @orderType
print(@SQL)
exec(@SQL)
END