小云熊

ASP.NET Repeater 控件分页
 1   protected void Page_Load(object sender, EventArgs e)
 2         {
 3             HttpContext context = HttpContext.Current;
 4             context.User.Identity.
 5             if(!IsPostBack)
 6             {
 7                 currPage.Text="1";
 8                 bindData();
 9             }
10            
11         }      
12         protected void bindData()
13         {
14             ///获取数据
15             string sql = "select * from SA_Tree";
16             SqlConnection con = new SqlConnection(connectStr);
17             DataSet ds = new DataSet();
18             SqlDataAdapter da = new SqlDataAdapter(sql,con);
19             da.Fill(ds,"test");
20 
21             //实例化数据绑定控件
22             PagedDataSource ps = new PagedDataSource();
23             ps.AllowPaging = true;//设置允许分页
24             ps.DataSource = ds.Tables["test"].DefaultView;//设置数据源
25             ps.PageSize = 5;//设置每页显示的行数
26             
27             ps.CurrentPageIndex = Convert.ToInt32(currPage.Text) - 1;//设置当前页索引
28             
29             
30             totalPage.Text = ps.PageCount.ToString();
31             //判断当前页是否为首页
32             if (ps.IsFirstPage)
33             {
34                 BtnPre.Enabled = false;
35             }
36             else
37             {
38                 BtnPre.Enabled = true;
39             }
40             //判断当前页是否为最后一页
41             if (ps.IsLastPage)
42             {
43                 BtnNext.Enabled = false;
44             }
45             else
46             {
47                 BtnNext.Enabled = true;
48             }
49             Repeater1.DataSource = ps;
50             Repeater1.DataBind();
51         }
52         
53         protected void BtnFirst_Click(object sender, EventArgs e)
54         {
55             currPage.Text = "1";
56             bindData();
57         }
58         protected void BtnNext_Click(object sender, EventArgs e)
59         {
60             currPage.Text = (Convert.ToInt32(currPage.Text)+1).ToString();
61             bindData();
62         }
63         protected void BtnLast_Click(object sender, EventArgs e)
64         {
65             currPage.Text = totalPage.Text;
66             bindData();
67         }
68         protected void BtnPre_Click(object sender, EventArgs e)
69         {
70             currPage.Text = (Convert.ToInt32(currPage.Text) - 1).ToString();
71             bindData();
72         }
服务端
<form id="form1" runat="server">
        <div>
            <span>
                <asp:Label ID="currPage" runat="server"></asp:Label>/<asp:Label ID="totalPage" runat="server"></asp:Label></span>
        </div>
    <div>
        <asp:Repeater ID="Repeater1" runat="server" >
            
            <HeaderTemplate>
                <table class="Treelist">
                   <tr>
                       <th>节点ID</th>
                       <th>节点名称</th>
                       <th>父节点</th>
                       <th></th>
                   </tr>
                
            </HeaderTemplate>
            <ItemTemplate>
                <tr>
                       <th><%# Eval("NodeID") %></th>
                       <th><%# Eval("TreeText") %></th>
                       <th><%# Eval("ParentID") %></th>
                       <th></th>
                   </tr>
            </ItemTemplate>
            <FooterTemplate>
                
                </table>
            </FooterTemplate>
        </asp:Repeater>
         <table>
                     <tr>
                         
                         <td><asp:Button ID="BtnFirst" runat="server" Text="首页" OnClick="BtnFirst_Click"/></td>
                         <td><asp:Button ID="BtnPre" runat="server" Text="上一页" OnClick="BtnPre_Click"/></td>
                         <td><asp:Button ID="BtnNext" runat="server" Text="下一页" OnClick="BtnNext_Click" /></td>
                         <td><asp:Button ID="BtnLast" runat="server" Text="尾页" OnClick="BtnLast_Click"/></td>
                     </tr>
                 </table>
        
    </div>
    </form>
客户端

 

posted on 2015-11-04 16:02  小云熊  阅读(152)  评论(0)    收藏  举报