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

    }
    protected void btnButton1_Click(object sender, EventArgs e)
    {
        string guestType = Request.QueryString["id"];
        
        //通过验证控件的验证
        if (Page.IsValid)
        {

            string sguestName = guestName.Text;
            string sguestFrom = guestFrom.Text;
            string sguestTitle = "";//guestTitle.Text; //回复没有标题
            string sguestContent = guestContent.Text;
            string sguestFace = ""; // guestFace.Text; //回复没有头像
            string sguestQQ = guestQQ.Text;
            string sguestMSN = guestMSN.Text;
            string sguestHomePage = guestHomePage.Text;
            string sguestEmail = guestEmail.Text;
            string sguestTel = guestTel.Text;
            string sguestDatetime = System.DateTime.Now.ToString();
            //string sguestIP = Request.ServerVariables["REMOTE_ADDR"];//Page.Request.UserHostAddress.ToString();
            string sguestIP = Page.Request.UserHostAddress;
            int guestIsPassed = 0;   //0 不显示 1 显示  可设置,经管理员审核后才能显示

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

            objConnection.Open();
            //string strsql = "Insert Into tGuestBook(guestName,guestFrom,guestContent,guestIP,guestType)Values('" + sguestName + "','" + sguestFrom + "','" + sguestContent + "','"+Page.Request.UserHostAddress+"','" + guestType + "' )";
            string strsql = "Insert Into tGuestBook(guestName,guestFrom,guestTitle,guestContent,guestFace,guestQQ,guestMSN,guestHomePage,guestEmail,guestTel,guestDatetime,guestIP,guestType,guestIsPassed)Values('"
    + sguestName + "','" + sguestFrom + "','" + sguestTitle + "','" + sguestContent + "','" + sguestFace + "','" + sguestQQ + "','" + sguestMSN + "','" + sguestHomePage + "','" + sguestEmail + "','" + sguestTel + "','" + sguestDatetime + "','" + sguestIP + "'," + guestType +","+guestIsPassed+" )";


            OleDbCommand objCommand = new OleDbCommand(strsql , objConnection);
            int ok=objCommand.ExecuteNonQuery();
            if (ok>0){
                addOK.Text = "添加回复成功,经管理员审核后才能显示";
            }
            objConnection.Close();



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



}