.NET实现Repeater控件+AspNetPager控件分页

2024-07-10 13:29:40

字体：大中小

来源：转载

供稿：网友

本文给大家分享的2个示例，演示AspNetPager最基本的功能，帮助您认识AspNetPager分页控件及了解它的工作原理。有需要的小伙伴可以参考下

当然首先你要把bin文件放进你的项目，并加到你的工具栏去

//页头需引用的

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

控件部分（格式已经设计好）

<webdiyer:AspNetPager ID="AspNetPager1" runat="server" AlwaysShow="True" FirstPageText="<font face='Webdings'>9</font>"

LastPageText="<font face='Webdings'>:</font>" NextPageText="<font face='Webdings'>8</font>"

PrevPageText="<font face='Webdings'>7</font>" ShowCustomInfoSection="Left" InputBoxStyle="width:19px"

TextAfterInputBox="页" TextBeforeInputBox="转到第" CustomInfoHTML="共检索到<strong>%RecordCount%</strong>条记录页次：<strong>%CurrentPageIndex%/%PageCount%</strong> 每页<strong>%PageSize%</strong>条"

HorizontalAlign="Right" Width="100%" ShowInputBox="Always" OnPageChanged="AspNetPager1_PageChanged"

PageSize="20" ShowBoxThreshold="1">

</webdiyer:AspNetPager>

后台绑定的代码

void databind()

{

int QYId = Convert.ToInt32(Request.Cookies["CompenyUser"].Value);//企业的Id

DataTable dt = bll.Viewlist(QYId);

this.AspNetPager1.RecordCount = dt.Rows.Count;//获取数据的总数

PagedDataSource pds = new PagedDataSource();

pds.DataSource = dt.DefaultView;//为控件绑定数据

pds.AllowPaging = true;//分页启用

pds.PageSize = AspNetPager1.PageSize;//获取每页显示的数量

pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;

Repeater1.DataSource = pds;

Repeater1.DataBind();

}

分页，只需要把绑定放在AspNetPager1_PageChanged 事件里

再给大家一个实例

前台页面代码

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TF_Product.aspx.cs" Inherits="TF_Product" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%@ Register assembly="AspNetPager" namespace="Wuqi.Webdiyer" tagprefix="webdiyer" %>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title>通服产品</title>

<script src="jquery.js" type="text/javascript"></script>

<script type="text/javascript">

$(document).ready(function()

{

//slides the element with class "menu_body" when paragraph with class "menu_head" is clicked

$("#firstpane p.menu_head").click(function()

{

$(this).css({backgroundImage:"url(down.png)"}).next("div.menu_body").slideToggle(300).siblings("div.menu_body").slideUp("slow");

$(this).siblings().css({backgroundImage:"url(left.png)"});

});

});

</script>

<style type="text/css">

.menu_list { width: 229px; font-size:13px; }

.menu_head { padding: 8px 60px; cursor: pointer; position: relative; margin:1px; height:16px; background: #DFEDFA url(left.png) center right no-repeat; }

.menu_body { display:none;}

.menu_body a { display:block; color:#006699; background-color:#EFEFEF; padding-left:60px; padding-top:8px; padding-bottom:3px; text-decoration:none; }

.menu_body a:hover { color: #000000; text-decoration:underline; }

</style>

<meta name="keywords" content="通服科技">

<meta name="description" content="江西通服科技有限公司">

<link href="./Index_files/style.css" type="text/css" rel="stylesheet">

<script src="js/AC_RunActiveContent.js" type="text/javascript"></script>



<style type="text/css">

.anpager{background:#DFEDFA none repeat scroll 0 0;border:1px solid #CCCCCC;color:#FFFFFF;padding:4px 5px 4px 5px;}

.container, .container *{margin:0; padding:0;}

.container{width:886px; height:267px; overflow:hidden;position:relative;}

.slider{position:absolute;}

.slider li{ list-style:none;display:inline;}

.slider img{ width:886px; height:267px; display:block;}

.num{ position:absolute; right:5px; bottom:5px;}

.num li{

float: left;

color: #FF7300;

text-align: center;

line-height: 16px;

width: 16px;

height: 16px;

font-family: Arial;

font-size: 12px;

cursor: pointer;

overflow: hidden;

margin: 3px 1px;

border: 1px solid #FF7300;

background-color: #fff;

}

.num li.on{

color: #fff;

line-height: 21px;

width: 21px;

height: 21px;

font-size: 16px;

margin: 0 1px;

border: 0;

background-color: #FF7300;

font-weight: bold;

}

</style>



</head>

<body>

<form runat="server">



<table width="878" height="114" border="0" align="center" cellpadding="0" cellspacing="2" bgcolor="#FFFFFF">

<tbody>

<tr>

<td height="77">

<table width="878px" border="0" cellpadding="0" cellspacing="0">

<tbody>

<tr><td width="73%" height="53" rowspan="2" align="left"><img src="./Index_files/LOGO_SY180-60.png" width="178" height="60" border="0"></td>

<td width="27%" align="right" valign="top">

【登陆】【注册】

</td>

</tr>

</tbody>

</table>

</td>

</tr>

<tr>

<td width="878" align="center" style=" border-bottom:1px solid blue;" ><div style="width:100px; float:left;"></div>

<div id="nav" align="center">

<a href="Default.aspx" target="_self" style="color:Black;">首页 |</a></div>

<div id="nav" align="center">

<a href="TF_RecList.aspx" target="_self" style="color:Black;">新闻中心 |</a></div>

<div id="nav" align="center">

<a href="TF_Product.aspx" target="_self" style="color:Black;">通服产品 |</a></div>

<div id="nav" align="center">

<a href="TF_Objects.aspx" target="_self" style="color:Black;">公司业绩 |</a></div>

<div id="nav" align="center">

<a href="TF_Servers.aspx" target="_self" style="color:Black;">服务中心 |</a></div>

<div id="nav" align="center">

<a href="TF_Solution.aspx" target="_self" style="color:Black;">解决方案 |</a></div>

<div id="nav" align="center">

<a href="AboutUs.aspx" target="_self" style="color:Black;">关于我们 |</a></div>

</td>

</tr>

<tr>

<td align="center" width="878px">

<div class="container" id="idTransformView">

<ul class="slider" id="idSlider">

<li><img src="images/01.jpg"/></li>

</ul>

</div>

</td>

</tr>

</tbody>

</table>



<table width="890" border="0" align="center" cellpadding="0" cellspacing="2" bgcolor="#FFFFFF">

<tbody>

<tr>

<td>

<div style="border:1px solid #DFEDFA; height:26px; padding-top:5px; padding-left:1%">

<table width="100%">

<tr>

<td>首页 > 通服产品</td>

<td> </td><td> </td>

<td align="right"><a href="Default.aspx">返回首页</a></td>

</tr>

</table>

</div>

</td>

</tr>

</tbody>

</table>

<table width="890" border="0" align="center" cellpadding="0" cellspacing="2" bgcolor="#FFFFFF">

<tbody>

<tr>

<td width="229" valign="top">

<div>

<img src="img/20140305165205.jpg" width="229px" />

</div>

<div id="firstpane" class="menu_list">



<p class="menu_head">基建产品</p>

<div class="menu_body">

<a href="TF_Product.aspx?id=45">普通基建</a><a href="TF_Product.aspx?id=46">美化基建</a>

</div>

<p class="menu_head">无源器件</p>

<div class="menu_body">

<a href="TF_Product.aspx?id=5">天线</a> <a href="TF_Product.aspx?id=14">负载</a>

<a href="TF_Product.aspx?id=11">功分器</a> <a href="TF_Product.aspx?id=17">合路器</a>

<a href="TF_Product.aspx?id=47">耦合器</a> <a href="TF_Product.aspx?id=56">双工器</a>

<a href="TF_Product.aspx?id=70">AC安装配件</a> <a href="TF_Product.aspx?id=89">屏蔽器</a>

</div>

<p class="menu_head">防雷产品</p>

<div class="menu_body">

<a href="TF_Product.aspx?id=10">避雷器</a> <a href="TF_Product.aspx?id=57">防雷箱</a>

</div>

<p class="menu_head">电源产品</p>

<div class="menu_body">

<a href="TF_Product.aspx?id=12">开关电源</a> <a href="TF_Product.aspx?id=23">USP电源</a>

<a href="TF_Product.aspx?id=61">远供电源</a> <a href="TF_Product.aspx?id=81">电源配套</a>

</div>

<p class="menu_head">IP通讯类产品</p>

<div class="menu_body">

<a href="TF_Product.aspx?id=27">IP网络产品</a> <a href="TF_Product.aspx?id=29">IP无线产品</a>

<a href="TF_Product.aspx?id=30">IP安全产品</a> <a href="TF_Product.aspx?id=31">IP存储及服务器</a>

<a href="TF_Product.aspx?id=32">IP多媒体产品</a> <a href="TF_Product.aspx?id=33">IP管理产品</a>

<a href="TF_Product.aspx?id=71">H3C产品</a> <a href="TF_Product.aspx?id=72">迈普产品</a>

<a href="TF_Product.aspx?id=73">迪普产品</a>

</div>

<p class="menu_head">工程辅材</p>

<div class="menu_body">

<a href="TF_Product.aspx?id=6">射频组件</a> <a href="TF_Product.aspx?id=7">电缆组件</a>

<a href="TF_Product.aspx?id=8">光纤组件</a> <a href="TF_Product.aspx?id=9">五类缆组件</a>

<a href="TF_Product.aspx?id=18">接地线</a> <a href="TF_Product.aspx?id=62">辅材包</a>

<a href="TF_Product.aspx?id=82">套管</a> <a href="TF_Product.aspx?id=83">紧固件</a>

</div>

<p class="menu_head">连接器</p>

<div class="menu_body">

<a href="TF_Product.aspx?id=15">射频连接器</a> <a href="TF_Product.aspx?id=16">光纤连接器</a>

<a href="TF_Product.aspx?id=63">转换头</a>

</div>

<p class="menu_head">服务类</p>

<div class="menu_body">

<a href="TF_Product.aspx?id=58">工程建设类</a> <a href="TF_Product.aspx?id=59">工程维护类</a>

<a href="TF_Product.aspx?id=60">软件类</a>

</div>

<p class="menu_head">品牌分销</p>

<div class="menu_body">

<a href="TF_Product.aspx?id=87">华为产品</a>

</div>

<p class="menu_head">配件类</p>

<div class="menu_body">

<a href="TF_Product.aspx?id=67">配件类</a> <a href="TF_Product.aspx?id=86">标准件</a>

</div>

<p class="menu_head">其他</p>

<div class="menu_body">

<a href="TF_Product.aspx?id=66">邮费差额</a> <a href="TF_Product.aspx?id=69">工程类服务费用</a>

<a href="TF_Product.aspx?id=78">折扣</a> <a href="TF_Product.aspx?id=88">设备</a>

</div>

</div>

</td>

<td width="660" valign="top">

<div style="border-bottom:1px solid #DFEDFA; padding-left:2%; margin-left:2%;">

产品类别：<asp:DropDownList ID="ddlProductType" runat="server" DataTextField="pt_name" DataValueField="pt_id">

</asp:DropDownList>

关键字：<asp:TextBox ID="txtGJZ" runat="server"></asp:TextBox>

<asp:Button ID="btnSel" runat="server" Text="搜索" onclick="btnSel_Click" />

</div>

<div> </div>

<div>

<asp:Repeater ID="rp" runat="server">

<ItemTemplate>

<div style="margin-left:2%; border:1px solid #DFEDFA; padding:3px; margin-top:2px; margin-bottom:3px;">

<table width="100%">

<tr height="24px">

<td rowspan="4" width="90px">

<asp:Image ID="Image1" ImageUrl="~/Product_pic/NoPic.jpg" runat="server" Width="90px" Height="90px" />

</td>

<td width="9px"> </td>

<td width="60px">产品型号：</td>

<td><span style="float:left"><%#Eval("pr_guige")%></span><span style="float:right;"><a href="#">查看详情</a></span></td>

</tr>

<tr height="24px">

<td width="9px"> </td>

<td>产品编码：</td>

<td><%#Eval("pr_bianma")%></td>

</tr>

<tr height="30px">

<td width="9px"> </td>

<td>产品描述：</td>

<td><%#Eval("pr_ms")%></td>

</tr>

<tr><td height="8px"> </td></tr>

</table>

</div>

</ItemTemplate>

</asp:Repeater>

<div style="height:22px; margin-left:2%;" align="right">

<webdiyer:AspNetPager ID="AspNetPager1" CssClass="anpager" runat="server" FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PrevPageText="上一页"

onpagechanged="AspNetPager1_PageChanged" PageSize="6" ShowMoreButtons="False" ShowPageIndexBox="Never">

</webdiyer:AspNetPager>

</div>

</div>

</td>

</tr>

</tbody>

</table>



<table width="878" border="0" align="center">

<tbody>

<tr>

<td>

<img src="./Index_files/foot_02.gif" usemap="#foot" width="878">

</td>

</tr>

</tbody>

</table>

</form>

</body>

</html>

后台代码

Tb_productsHelper helper = new Tb_productsHelper();

IList<Tb_productsInfo> list = helper.GetAllListBySql(product_sql);

this.AspNetPager1.RecordCount = list.Count;//绑定总数量

this.AspNetPager1.AlwaysShow = true;

//先声明一个分页类对象

PagedDataSource ps = new PagedDataSource();

ps.AllowPaging = true;

ps.PageSize = this.AspNetPager1.PageSize;

ps.CurrentPageIndex = this.AspNetPager1.CurrentPageIndex-1;

ps.DataSource = list;

this.rp.DataSource = ps;

this.rp.DataBind();