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 update : System.Web.UI.Page
18    ...{
19        protected void Page_Load(object sender, EventArgs e)
20        ...{
21            this.Title = "更新记录";
22            DropDownList1.AutoPostBack = true;
23            if (!IsPostBack)
24            ...{
25                OleDbConnection conn = new OleDbConnection();
26                conn.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;" + "Data Source = " + Server.MapPath("App_Data/Myphonebook.mdb");
27                OleDbCommand com = new OleDbCommand("select * from 通信录", conn);
28                DataSet ds = new DataSet();
29                OleDbDataAdapter da = new OleDbDataAdapter();
30                da.SelectCommand =com;
31                da.Fill(ds,"通信录");
32                DataTable dt = ds.Tables["通信录"];
33                DataRow dRow = dt.Rows[0];
34                TextBox1.Text = dRow["电话"].ToString();
35                TextBox2.Text = dRow["Email"].ToString();
36                conn.Close();
37            }
38        }
39
40        protected void Button1_Click(object sender, EventArgs e)
41        ...{
42            OleDbConnection conn = new OleDbConnection();
43            conn.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;" + "Data Source = " + Server.MapPath("App_Data/Myphonebook.mdb");
44            OleDbCommand com = new OleDbCommand("select * from 通信录", conn);
45            DataSet ds = new DataSet();
46            OleDbDataAdapter da = new OleDbDataAdapter();
47            conn.Open();
48            string strUpdate = "update 通信录 set 电话=" +"'"+ TextBox1.Text + "'," + "Email=" +"'"+ TextBox2.Text+"'"+ " where 姓名='" + DropDownList1.Text + "'";
49            da.SelectCommand = com;
50            da.Fill(ds, "通信录");
51            OleDbCommand updateCom = new OleDbCommand(strUpdate,conn);
52            da.UpdateCommand = updateCom;
53            da.UpdateCommand.ExecuteNonQuery();
54            conn.Close();
55            Response.Write("<script language=javascript>alert('记录更新成功，请单击“返回”按钮回到主页面！');</script>");
56        }
57
58        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
59        ...{
60            OleDbConnection conn = new OleDbConnection();
61            conn.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;" + "Data Source = " + Server.MapPath("App_Data/Myphonebook.mdb");
62            OleDbCommand com = new OleDbCommand("select * from 通信录", conn);
63            DataSet ds = new DataSet();
64            OleDbDataAdapter da = new OleDbDataAdapter();
65            da.SelectCommand = com;
66            da.Fill(ds, "通信录");
67            DataTable dt = ds.Tables["通信录"];
68            int iname = DropDownList1.SelectedIndex;
69            DataRow dRow = dt.Rows[iname];
70            TextBox1.Text = dRow["电话"].ToString();
71            TextBox2.Text = dRow["Email"].ToString();
72            conn.Close();
73
74        }
75
76        protected void Button2_Click(object sender, EventArgs e)
77        ...{
78            Response.Redirect("default.aspx");
79        }
80    }
81}