1using System.Data.OleDb;
 2using System;
 3using System.Collections;
 4using System.Configuration;
 5using System.Data;
 6using System.Linq;
 7using System.Web;
 8using System.Web.Security;
 9using System.Web.UI;
10using System.Web.UI.HtmlControls;
11using System.Web.UI.WebControls;
12using System.Web.UI.WebControls.WebParts;
13using System.Xml.Linq;
14
15namespace Mypb
16...{
17    public partial class delete : System.Web.UI.Page
18    ...{
19        protected void Page_Load(object sender, EventArgs e)
20        ...{
21            this.Title = "删除记录";
22            Label1.Text = "单击“确定”将删除当前记录";
23        }
24
25        protected void Button1_Click(object sender, EventArgs e)
26        ...{
27            OleDbConnection conn = new OleDbConnection();
28            conn.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;" + "Data Source = " + Server.MapPath("App_Data/Myphonebook.mdb");
29            string strDel = "delete from 通信录 where 姓名='" + DropDownList1.SelectedItem.Text + "'";
30            OleDbCommand delCom = new OleDbCommand(strDel, conn);
31            OleDbDataAdapter da = new OleDbDataAdapter();
32            conn.Open();
33            da.DeleteCommand = delCom;
34            da.DeleteCommand.ExecuteNonQuery();
35            conn.Close();
36            Response.Write("<script language=javascript>alert('记录删除成功，请单击“返回”按钮回到主页面！');</script>");
37
38
39        }
40
41        protected void Button2_Click(object sender, EventArgs e)
42        ...{
43            Response.Redirect("default.aspx");
44        }
45    }
46}
47