.NET實現Repeater控制項+AspNetPager控制項分頁

來源:互聯網
上載者:User
當然首先你要把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">    <!--Code for menu starts here-->    <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();
相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.