guestbook_del.aspx.cs

来自「【程序主要功能】 1、精简的增删改查」· CS 代码 · 共 46 行

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

        string guest_ID = Request.QueryString["id"];
        //通过验证控件的验证
        if (guest_ID!=null)
        {
            string strConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
            OleDbConnection objConnection = new OleDbConnection(strConnection);
            objConnection.Open();

            string strsql = "delete from tGuestBook where guest_ID=" + guest_ID;
            OleDbCommand objCommand = new OleDbCommand(strsql , objConnection);
            int ok=objCommand.ExecuteNonQuery();
            if (ok > 0)
            {
                delOKInfo.Text = "删除成功！！！";
            }
            else { 
                delOKInfo.Text = "删除不成功！！！";
            }
            objConnection.Close();


        }
    }
}