加入收藏 | 设为首页 | 会员中心 | 我要投稿 源码门户网 (https://www.92codes.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > Asp教程 > 正文

repeater分页 内容显示

发布时间:2021-07-17 04:29:23 所属栏目:Asp教程 来源:互联网
导读:usingSystem; usingSystem.Collections; usingSystem.ComponentModel; usingSystem.Data; usingSystem.Drawing; usingSystem.Web; usingSystem.Web.SessionState; usingSystem.Web.UI; usingSystem.Web.UI.WebControls; usingSystem.Web.UI.HtmlControls; u
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

namespace note
{
    /// <summary>
    /// _default 的摘要说明。
    /// </summary>
    public class _default : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.Repeater rpt_sword_list;
        protected System.Web.UI.WebControls.Label lbl_count;
        protected System.Web.UI.WebControls.Label lbl_current_page;
        protected System.Web.UI.WebControls.Label lbl_total_page;
        protected System.Web.UI.WebControls.LinkButton lb_frist;
        protected System.Web.UI.WebControls.LinkButton lb_p;
        protected System.Web.UI.WebControls.LinkButton lb_n;
        protected System.Web.UI.WebControls.LinkButton lb_last;

        private void Page_Load(object sender, System.EventArgs e)
        {
            // 在此处放置用户代码以初始化页面
            if(!this.IsPostBack)
            {
                this.DB_Bind();
            }
        }

        private void DB_Bind()
        {
            int ipageindex = Convert.ToInt32(this.lbl_current_page.Text);
            OleDbConnection conn = dbconn.CreateConn();
            OleDbCommand cmd = new OleDbCommand("select * from a where flag=true order by cdate desc",conn);
            OleDbDataAdapter oda = new OleDbDataAdapter();
            oda.SelectCommand = cmd;
            DataSet ds = new DataSet();
            oda.Fill(ds,"sword_list");
            PagedDataSource pds = new PagedDataSource();
            pds.DataSource = ds.Tables["sword_list"].DefaultView;
            pds.AllowPaging = true;
            pds.PageSize = 5;
            pds.CurrentPageIndex = ipageindex - 1;
            this.lbl_total_page.Text = pds.PageCount.ToString();
            this.lbl_count.Text = pds.Count.ToString();
            this.lb_frist.Enabled = true;
            this.lb_p.Enabled = true;
            this.lb_n.Enabled = true;
            this.lb_last.Enabled = true;
            if(this.lbl_current_page.Text=="1")
            {
                this.lb_frist.Enabled = false;
                this.lb_p.Enabled = false;
            }
            if(this.lbl_current_page.Text==pds.PageCount.ToString())
            {
                this.lb_n.Enabled = false;
                this.lb_last.Enabled = false;
            }
            this.rpt_sword_list.DataSource = pds;
            this.rpt_sword_list.DataBind();
            conn.Close();
        }

        #region Web 窗体设计器生成的代码
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }

        /// <summary>
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
        /// 此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {    
            this.lb_frist.Click += new System.EventHandler(this.lb_frist_Click);
            this.lb_p.Click += new System.EventHandler(this.lb_p_Click);
            this.lb_n.Click += new System.EventHandler(this.lb_n_Click);
            this.lb_last.Click += new System.EventHandler(this.lb_last_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        private void lb_frist_Click(object sender, System.EventArgs e)
        {
            this.lbl_current_page.Text = "1";
            this.DB_Bind();
        }

        private void lb_p_Click(object sender, System.EventArgs e)
        {
            this.lbl_current_page.Text = Convert.ToString(Convert.ToInt32(this.lbl_current_page.Text)-1);
            this.DB_Bind();
        }

        private void lb_n_Click(object sender, System.EventArgs e)
        {
            this.lbl_current_page.Text = Convert.ToString(Convert.ToInt32(this.lbl_current_page.Text)+1);
            this.DB_Bind();
        }

        private void lb_last_Click(object sender, System.EventArgs e)
        {
            this.lbl_current_page.Text = this.lbl_total_page.Text;
            this.DB_Bind();
        }
    }
}

(编辑:源码门户网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    热点阅读