Repeater数据控件与aspnetpager分页控件使用例子：

效果图：

1）、把AspNetPager.dll文件(从网上下载)放到网站bin文件夹里

2）、在.aspx页引用分页控件的命名空间：

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

3）、这样就可以使用分页控件了

前台：

 

<form id="form1" runat="server"> <div> <div id="title"> <img src="images/department_work.gif" mce_src="images/department_work.gif" border="0px" />部门工作 </div> <div id="body"> <div id="select"> 关键字：<asp:TextBox ID="txtkeyWord" MaxLength="100" runat="server"></asp:TextBox>   查找方式：<asp:DropDownList ID="ddlStyle" Width="100px" runat="server"> <asp:ListItem Value="0">-按标题-</asp:ListItem> <asp:ListItem Value="1">-按作者-</asp:ListItem> <asp:ListItem Value="2">-按内容-</asp:ListItem> </asp:DropDownList>   <asp:Button ID="btSearch" runat="server" Height="20px" Text="搜索" onclick="btSearch_Click" /> </div> <div id="show"> <asp:Repeater id="repShowNews" runat="server" > <HeaderTemplate> <table class="table_style" width="100%" id="changecolor"> <tr style=" background-color:#ECF3FD;" > <th>标题</th> <th>作者</th> <th>内容摘要</th> </tr> </HeaderTemplate> <ItemTemplate> <tr> <td><a target="_blank" href='news/News_Details.aspx?id=<%#Eval("id")%>' ><%#StringTruncat(Eval("title").ToString(), 20, "...")%></a></td> <td><%#Eval("author").ToString().Trim() %></td> <td><%#StringTruncat(Eval("content").ToString().Trim(), 20, "...") %></td> </tr> </ItemTemplate> <FooterTemplate> </table> </FooterTemplate> </asp:Repeater> </div> <div id="page"> <webdiyer:AspNetPager ID="AspNetPager1" runat="server" CurrentPageButtonClass="biaogebg" CurrentPageButtonStyle="biaogebg" CustomInfoHTML="[第 %CurrentPageIndex% / %PageCount% 页] [共%RecordCount%条 %PageSize%条/页]　" FirstPageText="首页" LastPageText="尾页" LayoutType="Table" NextPageText="后一页" OnPageChanging="AspNetPager1_PageChanging" PrevPageText="上一页" ShowCustomInfoSection="Right" ShowPageIndexBox="Always" SubmitButtonText="Go" TextAfterPageIndexBox="页" TextBeforePageIndexBox="转到" ShowBoxThreshold="20" PagingButtonSpacing="8px" CenterCurrentPageButton="True" CustomInfoSectionWidth="30%" PageIndexBoxType="DropDownList" PageSize="15" ShowPrevNext="False"> </webdiyer:AspNetPager> </div> </div> </div> </form> 后台：

protected void Page_Load(object sender, EventArgs e) { if (Session["T_department"] != null) { if (!IsPostBack) { ViewState["dep_id"]=Session["T_department"].ToString().Trim(); ViewState["keyWord"] = ""; ViewState["style"] = ""; GetPager(); AspNetPager1.CurrentPageIndex = 1; GetDepNews(); } } else { Response.Write("<script type="text/javascript"> alert('登录时间过长，请重新登录！');window.top.location='../../default.htm' </script>"); } } //绑定部门新闻到Repeater控件 private void GetDepNews() { string sqlDataString = "declare @sqlString varchar(500);declare @whereString varchar(200);set @sqlString='select id,title,author,content from Mis_News where '; set @whereString=' checkone='+char(39)+'是'+char(39)+' and checktwo='+char(39)+'是'+char(39)+' and checkthree='+char(39)+'是'+char(39)+' and dep_id='+@dep_id; set @whereString+=case @style when '0' then ' and title like '+char(39)+'%'+@keyWord+'%'+char(39) when '1' then ' and author like '+char(39)+'%'+@keyWord+'%'+char(39) when '2' then ' and content like '+char(39)+'%'+@keyWord+'%'+char(39) when '' then '' end set @sqlString+=@whereString;execute( @sqlString)"; SqlParameter[] parasData = { new SqlParameter("@dep_id",ViewState["dep_id"].ToString().Trim()), new SqlParameter("@keyWord",ViewState["keyWord"].ToString().Trim()), new SqlParameter("@style",ViewState["style"].ToString().Trim()), }; SqlDataAdapter da = sqlhelper.QueryAdapter(sqlDataString, "mis", parasData); DataTable dt = new DataTable(); da.Fill(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, dt); repShowNews.DataSource = dt; repShowNews.DataBind(); } //绑定总页数到aspnetpager控件 private void GetPager( ) { string sqlPageString = "declare @sqlString varchar(500);declare @whereString varchar(200);set @sqlString='select count(id) from Mis_News where '; set @whereString=' checkone='+char(39)+'是'+char(39)+' and checktwo='+char(39)+'是'+char(39)+' and checkthree='+char(39)+'是'+char(39)+' and dep_id='+@dep_id; set @whereString+=case @style when '0' then ' and title like '+char(39)+'%'+@keyWord+'%'+char(39) when '1' then ' and author like '+char(39)+'%'+@keyWord+'%'+char(39) when '2' then ' and content like '+char(39)+'%'+@keyWord+'%'+char(39) when '' then '' end set @sqlString+=@whereString;execute( @sqlString)"; SqlParameter[] parasPage = { new SqlParameter("@keyWord",ViewState["keyWord"].ToString().Trim()), new SqlParameter("@dep_id",ViewState["dep_id"].ToString().Trim()), new SqlParameter("@style",ViewState["style"].ToString().Trim()), }; int count = sqlhelper.ExecuteSql(sqlPageString, "mis", parasPage); AspNetPager1.AlwaysShow = true; AspNetPager1.RecordCount = count; AspNetPager1.PageSize = 10; } //搜索 protected void btSearch_Click(object sender, EventArgs e) { ViewState["keyWord"] = txtkeyWord.Text.Trim(); ViewState["style"] = ddlStyle.SelectedValue.Trim(); //Response.Write(ViewState["style"].ToString().Trim() + ";" + ViewState["keyWord"].ToString()); //return; GetPager(); AspNetPager1.CurrentPageIndex = 1; GetDepNews(); } //分页 protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e) { AspNetPager1.CurrentPageIndex = e.NewPageIndex; GetPager(); GetDepNews(); } /// <summary> /// 将指定字符串按指定长度进行剪切， /// </summary> /// <param name= "oldStr "> 需要截断的字符串 </param> /// <param name= "maxLength "> 字符串的最大长度 </param> /// <param name= "endWith "> 超过长度的后缀 </param> /// <returns> 如果超过长度，返回截断后的新字符串加上后缀，否则，返回原字符串 </returns> public static string StringTruncat(string oldStr, int maxLength, string endWith) { if (string.IsNullOrEmpty(oldStr)||maxLength<1) { return endWith; } else { string strTmp = oldStr.Substring(0, maxLength); return strTmp + endWith; } }