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


public partial class guestBook_add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //首先建立一个数组
            ArrayList arr = new ArrayList();
            for (int i = 1; i < 51; i++)
            {
                arr.Add(i + ".gif");
            }
            //将数组捆绑到DropDownList控件上去
            guestFace.DataSource = arr;
            guestFace.DataBind();
        }

    }
    protected void btnButton1_Click(object sender, EventArgs e)
    {
        //通过验证控件的验证
        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,guestTitle,guestContent,guestFace,guestQQ,guestMSN,guestHomePage,guestEmail,guestTel,guestDatetime,guestIP,guestIsPassed)Values('"
                + sguestName + "','" + sguestFrom + "','" + sguestTitle + "','" + sguestContent + "','" + sguestFace + "','" + sguestQQ + "','" + sguestMSN + "','" + sguestHomePage + "','" + sguestEmail + "','" + sguestTel + "','" + sguestDatetime + "','" + sguestIP + "'," + guestIsPassed + " )";

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


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

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        Image1.ImageUrl = "skins/face/" + guestFace.SelectedValue;
    }
}