guestbook.aspx.cs

学生寝室管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;//引进连接Sql Server的命名空间
public partial class guestbook : System.Web.UI.Page
{
    SqlCommand cmd,cmd1;
    SqlConnection cn;
    string strsql;
    SqlDataAdapter da;
    DataSet ds = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            this.databindlist();
        }
    }
    public void databindlist()     //申请一个方法来绑定数据
    {
       
        cn = sqldata.createcon();//连接数据库,我把数据库封装到“sqldata”类中了
        cn.Open();         //打开连接
        int countpage = Convert.ToInt32(this.Labelye.Text);  //获取当前页面
        strsql = "select * from guestbook  order by id desc "; //Sql查询语句
        da = new SqlDataAdapter (strsql, cn);
        da.Fill(ds, "Result");        //填充数据
        System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();   //封装数据绑定控件类,与分页相关的属性
        ps.DataSource = ds.Tables["Result"].DefaultView;
        ps.AllowPaging = true;    //获取或实置一个植，指示是否在数据绑定控件中启用分页
        ps.PageSize = 6;     //获取或实置每页显示的条数
        ps.CurrentPageIndex = countpage - 1;  //获取或实置当前页的索引
        this.lblPageCount.Text = Convert.ToString(ps.PageCount);  //统计共有多少页

        this.Button1.Enabled = true;
        this.Button2.Enabled = true;

        if (countpage == 1)
        {
            this.Button1.Enabled = false;//如果当前页等于"1"，那么"Button1"不可用
        }
        if (countpage == ps.PageCount)
        {
            this.Button2.Enabled = false;//如果当前页等于"尾页"，那么"Button2"不可用
        }

        this.mydatalist.DataSource = ps;
        this.mydatalist.DataBind();//将数据源绑定到DataList

        SqlCommand  cmd1 = new SqlCommand ("select count(*) from guestbook", cn);
        this.lblRecordCount.Text = Convert.ToString(cmd1.ExecuteScalar());//统计共有多少条记录
        sqldata.pagecount = Convert.ToString(ps.PageCount);
        cn.Close();//关闭连接
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        this.Labelye.Text = Convert.ToString(Convert.ToInt32(this.Labelye.Text) - 1); //获取当前的页数
        this.databindlist();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        this.Labelye.Text = Convert.ToString(Convert.ToInt32(this.Labelye.Text) + 1); //获取下一页的页数
        this.databindlist();  //绑定数据源
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        this.Labelye.Text = "1"; //获取首页
        this.databindlist(); //绑定数据源
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        this.Labelye.Text =sqldata.pagecount; //获取尾页
        this.databindlist();  //绑定数据源
    }
}