studMessage.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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;

public partial class Default12 : System.Web.UI.Page
{
    SqlConnection conn;
    SqlCommand cmd;
    //SqlDataAdapter sda;
    SqlDataReader dr;
    //DataSet ds;
    string curPage;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.Label3.Text = "1";
            DataListDataBind();
        }
    }
    public void DataListDataBind()
    {
        curPage = this.Label3.Text;
        conn = sqldata.createCon();
        conn.Open();
        cmd = new SqlCommand();
        cmd.CommandText = "SELECT messageID,studName,studFace,content1,postTime,homeAdminName,replyTime,content2 from message order by postTime desc";
        cmd.Connection = conn;
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = cmd;
        DataSet ds = new DataSet();
        sda.Fill(ds, "message");
        PagedDataSource pds = new PagedDataSource();
        pds.AllowPaging = true;
        pds.PageSize = 2;
        pds.DataSource = ds.Tables["message"].DefaultView;
        pds.CurrentPageIndex = Convert.ToInt32(curPage) - 1;
        this.Label2.Text = pds.PageCount.ToString();
        this.Button2.Enabled = true;
        this.Button4.Enabled = true;
        if (curPage == "1")
        {
            this.Button2.Enabled = false;
        }
        if (curPage == pds.PageCount.ToString())
        {
            this.Button4.Enabled = false;
        }
        DataList1.DataSource = pds;
        DataList1.DataBind();