delmsg.aspx.cs

用C#+Access写的留言本

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;

public partial class Delmsg : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Admin"] == null)
        {
            Response.Write("<script>alert(\"对不起,您没有足够权限进行此操作！\");</script>");
            Response.Redirect("Login.aspx");
        }
        else
        {
            int ID = Convert.ToInt32(Request.QueryString["ID"]);
            string CommTex = "delete from GuestBook where ID = @ID";
            string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=";
            strConn += Server.MapPath(".\\Data\\BookData.mdb");
            OleDbConnection myConn = new OleDbConnection(strConn);
            myConn.Open();
            OleDbCommand oldConn = new OleDbCommand(CommTex, myConn);
            oldConn.Parameters.Add("@ID", OleDbType.Integer, 8).Value = ID;
            oldConn.ExecuteNonQuery();
            myConn.Close();
            Response.Write("<script>alert(\"删除成功\");</script>");
            Response.Redirect("Default.aspx");
        }
        
    }
}