guestbook_add.aspx.cs

来自「不需要刷新网页,无限加长。源代码！！！！！！！！！」· CS 代码 · 共 53 行

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)
    {

    }
    protected void btnButton1_Click(object sender, EventArgs e)
    {
        //通过验证控件的验证
        if (Page.IsValid)
        {
            string sguestName = guestName.Text;
            string sguestContent = guestContent.Text;
            string sguestFrom = guestFrom.Text;


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

            objConnection.Open();
            string strsql = "Insert Into tGuestBook(guestName,guestFrom,guestContent)Values('" + sguestName + "','" + sguestFrom + "','" + sguestContent + "' )";

            OleDbCommand objCommand = new OleDbCommand(strsql , objConnection);
            int ok=objCommand.ExecuteNonQuery();
            if (ok>0){
                addOK.Text = "添加成功";
            }
            objConnection.Close();



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