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 }