guestbook.aspx.cs

不需要刷新网页,无限加长。源代码！！！！！！！！！

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 index : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       

        string guest_ID = Request.QueryString["id"];

   
        //通过验证控件的验证
        if (guest_ID != null)
        {
            string strConnection1 = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
            OleDbConnection objConnection1 = new OleDbConnection(strConnection1);
            objConnection1.Open();

            string strsql1 = "delete from tGuestBook where guest_ID=" + guest_ID;
            OleDbCommand objCommand1 = new OleDbCommand(strsql1, objConnection1);
            int ok = objCommand1.ExecuteNonQuery();
            
            objConnection1.Close();


        }
        string strConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
        OleDbConnection objConnection = new OleDbConnection(strConnection);
        objConnection.Open();

        string strsql = "select * from tGuestBook ";
        OleDbCommand objCommand = new OleDbCommand(strsql, objConnection);
        guestBookList.DataSource = objCommand.ExecuteReader();//guestBookList就是下面的的ID
        guestBookList.DataBind();

        objConnection.Close();
    }
}