guestbook_update.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 admin_guestBook_guestBook_update : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Server.Execute("../incs/checkPurview.aspx");  // 此处用户权限验证



        
        if (Request.QueryString["id"] == null)
        {
            Response.Redirect("guestBook.aspx");
        }
        if (!IsPostBack)
        {
            //首先建立一个数组
            ArrayList arr = new ArrayList();
            for (int i = 1; i < 51; i++)
            {
                arr.Add(i + ".gif");
            }
            //将数组捆绑到DropDownList控件上去
            guestFace.DataSource = arr;
            guestFace.DataBind();
       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();
            guestFace.SelectedValue = objDataReader["guestFace"].ToString();
                 Image1.ImageUrl = "skins/face/" + guestFace.SelectedValue; 
            guestFrom.Text = objDataReader["guestFrom"].ToString();
            guestQQ.Text = objDataReader["guestQQ"].ToString();
            guestMSN.Text = objDataReader["guestMSN"].ToString();
            guestHomePage.Text = objDataReader["guestHomePage"].ToString();
            guestEmail.Text = objDataReader["guestEmail"].ToString();
            guestTel.Text = objDataReader["guestTel"].ToString();
            guestTitle.Text = objDataReader["guestTitle"].ToString();
            guestContent.Text = objDataReader["guestContent"].ToString();
            guest_ID.Value = objDataReader["guest_ID"].ToString();
        }

        objConnection.Close();
        } 
    }
    protected void btnButton1_Click(object sender, EventArgs e)
    {
        //通过验证控件的验证
        if (Page.IsValid)
        {
            //string name = guestName.Text;
            string sguestName = Request.Form["guestName"];
            string sguestFrom = Request.Form["guestFrom"];
            string sguestTitle = Request.Form["guestTitle"];
            string sguestContent = Request.Form["guestContent"];
            string sguestFace = Request.Form["guestFace"];
            string sguestQQ = Request.Form["guestQQ"];
            string sguestMSN = Request.Form["guestMSN"];
            string sguestHomePage = Request.Form["guestHomePage"];
            string sguestEmail = Request.Form["guestEmail"];
            string sguestTel = Request.Form["guestTel"];
            //string sguestDatetime = System.DateTime.Now.ToString();
            //string sguestIP = Request.ServerVariables["REMOTE_ADDR"];//Page.Request.UserHostAddress.ToString();
            //string sguestIP = Page.Request.UserHostAddress;
            //int guestIsPassed = 1;   //0 不显示 1 显示  可设置,经管理员审核后才能显示

            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='" + sguestName + "',guestFrom='" + sguestFrom + "',guestTitle='" + sguestTitle + "',guestContent='" + sguestContent + "',guestFace='"+sguestFace+"',guestQQ='"+sguestQQ+"',guestMSN='"+sguestMSN+"',guestHomePage='"+sguestHomePage+"',guestEmail='"+sguestEmail+"',guestTel='"+sguestTel+"' 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");
        }
    }

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



}