guestbook.aspx.cs

【程序主要功能】 1、精简的增删改查

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;

public partial class guestBook : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {
        string strConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
        OleDbConnection objConnection = new OleDbConnection(strConnection);
        objConnection.Open();

        string strsql = "select * from tGuestBook where guestIsPassed=1 and guestType=0 order by guestDatetime desc";
        OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strsql, objConnection); 
        //建立DataSet对象ds;利用Adapter的Fill方法把SQL命令执行的结果倒入DataSet对象
        DataSet ds = new DataSet();
        MyAdapter.Fill(ds, "GuestBook");

        OleDbDataAdapter MyAdapter2 = new OleDbDataAdapter("select * from tGuestBook where guestIsPassed=1 order by guestDatetime asc", objConnection);
        MyAdapter2.Fill(ds, "reply");
        //建立嵌套关系
        ds.Relations.Add("myrelation", ds.Tables["GuestBook"].Columns["guest_ID"], ds.Tables["reply"].Columns["guestType"] , false );

        //guestBookList.DataSource = ds.Tables["GuestBook"];
        //Page.DataBind();
        objConnection.Close();

        //分页 开始 -------
        int CurPage;
        if (Request.QueryString["Page"] != null && Convert.ToInt32(Request.QueryString["Page"]) > 0)
            CurPage = Convert.ToInt32(Request.QueryString["Page"]);
        else
            CurPage = 1;
        PagedDataSource ps = new PagedDataSource();
        ps.DataSource = ds.Tables["GuestBook"].DefaultView;
        ps.AllowPaging = true;
        //每个页面显示的条数
        ps.PageSize = 2;
        onePage.Text = ps.PageSize.ToString();
        //求数据的总数
        allMsg.Text = ps.DataSourceCount.ToString();
        ps.CurrentPageIndex = CurPage - 1;
        //求总页
        allPages.Text = ps.PageCount.ToString();
        nowPage.Text = CurPage.ToString();
        //将数据源与控件绑定
        guestBookList.DataSource = ps;
        guestBookList.DataBind();

        //上一页
        if (!ps.IsFirstPage)
        {
            firstPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";
            prePage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
        }
        //下一页
        if (!ps.IsLastPage)
        {
            nextPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
            endPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(ps.PageCount);
        }
        //分页 结束 -------


    }

}