access数据库分页程序
- <div class="page" id="ctrlRecordPage">
- 总<asp:Label ID="Zpage" runat="server" Text="1"></asp:Label>页/
- <asp:Label ID="Zcount" runat="server" Text="0"></asp:Label>条
- <asp:LinkButton ID="start_button" runat="server" onclick="start_button_Click">首页</asp:LinkButton>
- <asp:LinkButton ID="up_button" runat="server" onclick="up_button_Click">上一页</asp:LinkButton>
- <asp:LinkButton ID="down_button" runat="server" onclick="down_button_Click">下一页</asp:LinkButton>
- <asp:LinkButton ID="end_button" runat="server" οnclick="end_button_Click">末页</asp:LinkButton>
- 每页<asp:TextBox ID="Pagesize" runat="server" Text="10" Width="30px"></asp:TextBox>条
- 当前<asp:DropDownList ID="Pageing" runat="server" AutoPostBack="True"
- onselectedindexchanged="Pageing_SelectedIndexChanged"></asp:DropDownList>页
- </div>
- private void Pageing_databird(int value)
- {
- Pageing.Items.Clear();
- int zdatapage = Convert.ToInt32(Zpage.Text);
- if (zdatapage > 0)
- {
- for (int i = 1; i <= zdatapage; i++)
- {
- Pageing.Items.Add(i.ToString());
- }
- }
- else
- {
- Pageing.Items.Add("1");
- }
- if (Pageing.Items.FindByValue(value.ToString()) != null) Pageing.SelectedValue = value.ToString();
- if (zdatapage > 1)
- {
- Pageing.Enabled = true;
- int datapageing = Convert.ToInt32(Pageing.SelectedValue);
- if (datapageing > 1)
- {
- start_button.Enabled = true;
- up_button.Enabled = true;
- }
- else
- {
- start_button.Enabled = false;
- up_button.Enabled = false;
- }
- if (datapageing < zdatapage)
- {
- down_button.Enabled = true;
- end_button.Enabled = true;
- }
- else
- {
- down_button.Enabled = false;
- end_button.Enabled = false;
- }
- }
- else
- {
- start_button.Enabled = false;
- up_button.Enabled = false;
- down_button.Enabled = false;
- end_button.Enabled = false;
- Pageing.Enabled = false;
- }
- }
- protected void start_button_Click(object sender, EventArgs e)
- {
- int datapageing = 1;
- if (Pageing.Items.FindByValue(datapageing.ToString()) != null) Pageing.SelectedValue = datapageing.ToString();
- DataBird();
- }
- protected void up_button_Click(object sender, EventArgs e)
- {
- int datapageing = Convert.ToInt32(Pageing.SelectedValue);
- if(datapageing>1)datapageing--;
- if (Pageing.Items.FindByValue(datapageing.ToString()) != null) Pageing.SelectedValue = datapageing.ToString();
- DataBird();
- }
- protected void down_button_Click(object sender, EventArgs e)
- {
- int datapageing = Convert.ToInt32(Pageing.SelectedValue);
- int zdatapage = Convert.ToInt32(Zpage.Text);
- if (datapageing < zdatapage) datapageing++;
- if (Pageing.Items.FindByValue(datapageing.ToString()) != null) Pageing.SelectedValue = datapageing.ToString();
- DataBird();
- }
- protected void end_button_Click(object sender, EventArgs e)
- {
- int zdatapage = Convert.ToInt32(Zpage.Text);
- if (Pageing.Items.FindByValue(zdatapage.ToString()) != null) Pageing.SelectedValue = zdatapage.ToString();
- DataBird();
- }
- protected void Pageing_SelectedIndexChanged(object sender, EventArgs e)
- {
- DataBird();
- }
- protected void DataBird()
- {
- dc.Setsql = "select * from adlist order by createtime desc";
- DataTable dt = dc.GetDataTable(0);
- PagedDataSource pds = new PagedDataSource();
- pds.DataSource = dt.DefaultView;
- pds.AllowPaging = true;
- int datapagesize = 10;
- if (Convert.ToInt32(Pagesize.Text) > 0) datapagesize = Convert.ToInt32(Pagesize.Text);
- pds.PageSize = datapagesize;
- Zcount.Text = pds.DataSourceCount.ToString();
- Zpage.Text = pds.PageCount.ToString();
- int zpaging = 1;
- if (Pageing.SelectedIndex > -1) zpaging = Convert.ToInt32(Pageing.SelectedValue);
- Pageing_databird(zpaging);
- pds.CurrentPageIndex = Convert.ToInt32(Pageing.SelectedValue) - 1;
- listshow_Repeater.DataSource = pds;
- listshow_Repeater.DataBind();
- }
ok了!