asp.net access数据库分页

access数据库分页程序

 

1. <div class="page" id="ctrlRecordPage"> 
2.                         总<asp:Label ID="Zpage" runat="server" Text="1"></asp:Label>页/
3.                           <asp:Label ID="Zcount" runat="server" Text="0"></asp:Label>条   
4.                         <asp:LinkButton ID="start_button" runat="server" onclick="start_button_Click">首页</asp:LinkButton>
5.                         <asp:LinkButton ID="up_button" runat="server" onclick="up_button_Click">上一页</asp:LinkButton> 
6.                         <asp:LinkButton ID="down_button" runat="server" onclick="down_button_Click">下一页</asp:LinkButton> 
7.                         <asp:LinkButton ID="end_button" runat="server" οnclick="end_button_Click">末页</asp:LinkButton>&nbsp;&nbsp;                                 
8.                         每页<asp:TextBox ID="Pagesize" runat="server" Text="10" Width="30px"></asp:TextBox>条  
9.                         当前<asp:DropDownList ID="Pageing" runat="server" AutoPostBack="True" 
10.                             onselectedindexchanged="Pageing_SelectedIndexChanged"></asp:DropDownList>页
11.                     </div>

 

1. private void Pageing_databird(int value)
2.         {
3.             Pageing.Items.Clear();
4.             int zdatapage = Convert.ToInt32(Zpage.Text);
5.             if (zdatapage > 0)
6.             {
7.                 for (int i = 1; i <= zdatapage; i++)
8.                 {
9.                     Pageing.Items.Add(i.ToString());
10.                 }
11.             }
12.             else
13.             {
14.                 Pageing.Items.Add("1");
15.             }
16.             if (Pageing.Items.FindByValue(value.ToString()) != null) Pageing.SelectedValue = value.ToString();
17.             if (zdatapage > 1)
18.             {
19.                 Pageing.Enabled = true;
20.                 int datapageing = Convert.ToInt32(Pageing.SelectedValue);
21.                 if (datapageing > 1)
22.                 {
23.                     start_button.Enabled = true;
24.                     up_button.Enabled = true;                    
25.                 }
26.                 else
27.                 {
28.                     start_button.Enabled = false;
29.                     up_button.Enabled = false;
30.                 }
31.                 if (datapageing < zdatapage)
32.                 {
33.                     down_button.Enabled = true;
34.                     end_button.Enabled = true;
35.                 }
36.                 else
37.                 {
38.                     down_button.Enabled = false;
39.                     end_button.Enabled = false;
40.                 }
41.             }
42.             else
43.             {
44.                 start_button.Enabled = false;
45.                 up_button.Enabled = false;
46.                 down_button.Enabled = false;
47.                 end_button.Enabled = false;
48.                 Pageing.Enabled = false;
49.             }
50.         }
52.         protected void start_button_Click(object sender, EventArgs e)
53.         {
54.             int datapageing = 1;
55.             if (Pageing.Items.FindByValue(datapageing.ToString()) != null) Pageing.SelectedValue = datapageing.ToString();
56.             DataBird();
57.         }
59.         protected void up_button_Click(object sender, EventArgs e)
60.         {
61.             int datapageing = Convert.ToInt32(Pageing.SelectedValue);
62.             if(datapageing>1)datapageing--;
63.             if (Pageing.Items.FindByValue(datapageing.ToString()) != null) Pageing.SelectedValue = datapageing.ToString();
64.             DataBird();
65.         }
67.         protected void down_button_Click(object sender, EventArgs e)
68.         {
69.             int datapageing = Convert.ToInt32(Pageing.SelectedValue);
70.             int zdatapage = Convert.ToInt32(Zpage.Text);
71.             if (datapageing < zdatapage) datapageing++;
72.             if (Pageing.Items.FindByValue(datapageing.ToString()) != null) Pageing.SelectedValue = datapageing.ToString();
73.             DataBird();
74.         }
76.         protected void end_button_Click(object sender, EventArgs e)
77.         {
78.             int zdatapage = Convert.ToInt32(Zpage.Text);
79.             if (Pageing.Items.FindByValue(zdatapage.ToString()) != null) Pageing.SelectedValue = zdatapage.ToString();
80.             DataBird();
81.         }
83.         protected void Pageing_SelectedIndexChanged(object sender, EventArgs e)
84.         {
85.             DataBird();
86.         }
92.  protected void DataBird()
93.         {
94.             dc.Setsql = "select * from adlist order by createtime desc";
95.             DataTable dt = dc.GetDataTable(0);
96.             PagedDataSource pds = new PagedDataSource();
97.             pds.DataSource = dt.DefaultView;
98.             pds.AllowPaging = true;
99.             int datapagesize = 10;
100.             if (Convert.ToInt32(Pagesize.Text) > 0) datapagesize = Convert.ToInt32(Pagesize.Text);
101.             pds.PageSize = datapagesize;
102.             Zcount.Text = pds.DataSourceCount.ToString();
103.             Zpage.Text = pds.PageCount.ToString();
104.             int zpaging = 1;
105.             if (Pageing.SelectedIndex > -1) zpaging = Convert.ToInt32(Pageing.SelectedValue);
106.             Pageing_databird(zpaging);
107.             pds.CurrentPageIndex = Convert.ToInt32(Pageing.SelectedValue) - 1;
108.             listshow_Repeater.DataSource = pds;
109.             listshow_Repeater.DataBind();
110.         }

 

ok了！