guestbook_update.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;
using System.Data.SqlClient;


public partial class guestBook_add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
            
        if (Request.QueryString["id"] == null)
        {
            Response.Redirect("guestBook.aspx");
        }
        string sguest_ID = Request.QueryString["id"];

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

        string strsql = "select * from tGuestBook where guest_ID=" + sguest_ID;
        OleDbCommand objCommand = new OleDbCommand(strsql, objConnection);
        //guestBookList.DataSource = objCommand.ExecuteReader();//guestBookList就是下面的的ID
        //guestBookList.DataBind();
        OleDbDataReader objDataReader = objCommand.ExecuteReader();
        if (objDataReader.Read())
        {

            guestName.Text = objDataReader["guestName"].ToString();
            guest_ID.Value = objDataReader["guest_ID"].ToString();
            guestFrom.Text = objDataReader["guestFrom"].ToString();
            guestContent.Text = objDataReader["guestContent"].ToString();
        } 

        objConnection.Close();

    }
    protected void btnButton1_Click(object sender, EventArgs e)
    {
        //通过验证控件的验证
        if (Page.IsValid)
        {
            //string name = guestName.Text;
            guestName.Text = Request.Form["guestName"];
            guestFrom.Text = Request.Form["guestFrom"];
            guestContent.Text = Request.Form["guestContent"];
            string saguest_ID = guest_ID.Value;

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

            string strsql = "update tGuestBook set guestName='" + guestName.Text + "',guestFrom='" + guestFrom.Text + "',guestContent='" + guestContent.Text + "' where guest_ID=" + saguest_ID;
            OleDbCommand objCommand = new OleDbCommand(strsql , objConnection);
            
            int ok=objCommand.ExecuteNonQuery();
            if (ok>0){
                updateOKinfo.Text = "修改成功" ;
            }else{
                updateOKinfo.Text = "修改不成功";
            }
            objConnection.Close();



            //重定向到留言页面
            //Response.Redirect("guestBook.aspx");
        }
    }
}