datalist分页

最新推荐文章于 2021-03-11 14:53:03 发布

zhypmq

最新推荐文章于 2021-03-11 14:53:03 发布

阅读量460

点赞数

文章标签： dataset object button date system string

本文链接：https://blog.csdn.net/zhypmq/article/details/1750568

版权

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    private DataSet myDS = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
        {
            Label1.Text = "1";//默认为第一页
            Date_load();
        }
    }
    private void Date_load()
    {
        int curypage =Convert.ToInt32( Label1.Text); //当前页码
        SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
        string mySqlstr = "select * from MessgeBook order by MessegBook_id desc";
        SqlDataAdapter myDataAdpter = new SqlDataAdapter(mySqlstr,myConnection);
        //打开数据库连接
        myConnection.Open();
        //填充数据
        myDataAdpter.Fill(myDS, "MessgeBook");

        //关闭连接
        myConnection.Close();
        PagedDataSource ps = new PagedDataSource();
        ps.DataSource = myDS.Tables["MessgeBook"].DefaultView;
        ps.AllowPaging = true;//允许分布
        ps.PageSize = 3;//每页多少条
        Label4.Text =Convert.ToString(ps.PageCount);//共多少页
        ps.CurrentPageIndex = curypage - 1;//当前页(当前页从零开始,因为curypage默认为１所以要减去１)
        this.Button1.Enabled = true;
        this.Button2.Enabled = true;
        if (curypage==1)
        {
            this.Button1.Enabled = false;
        }
        if(curypage==ps.PageCount)
        {
            this.Button2.Enabled = false;
        }
        //邦定数据
        Repeater1.DataSource = ps;
        Repeater1.DataBind();
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        this.Label1.Text = Convert.ToString(Convert.ToInt32(this.Label1.Text) - 1);
        this.Date_load();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        this.Label1.Text = Convert.ToString(Convert.ToInt32(this.Label1.Text) + 1);
        this.Date_load();
    }
}