1    
 2     protected void ViewData_Click(object sender, EventArgs e)
 3     {
 4         string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
 5         strConnection += Server.MapPath("mydata.mdb");
 6         OleDbConnection objConnection = new OleDbConnection(strConnection);
 7 
 8         OleDbCommand objCommand = new OleDbCommand("select*from 通信录", objConnection);
 9         objConnection.Open();
10         OleDbDataReader objDataReader = objCommand.ExecuteReader();
11         String str = "             ";
12         ArrayList values = new ArrayList();
13         while (objDataReader.Read())
14         {
15             TBId.Text=Convert.ToString(objDataReader["ID"]);
16             TBName.Text = Convert.ToString(objDataReader["name"]);
17             TBClass.Text=Convert.ToString(objDataReader["classm"]);
18             TBTelephone.Text = Convert.ToString(objDataReader["telephone"]);
19             TBEmail.Text = Convert.ToString(objDataReader["Email"]);
20             TBAdress.Text = Convert.ToString(objDataReader["Adress"]);
21           
22             String str2=Convert.ToString(objDataReader["ID"]) + str + Convert.ToString(objDataReader["name"]) + str + Convert.ToString(objDataReader["classm"]) + str + Convert.ToString(objDataReader["telephone"]) + str + Convert.ToString(objDataReader["Email"])+ str + Convert.ToString(objDataReader["Adress"]);
23             values.Add(str2);
24             //Response.Write("<br>");//输出回车换行
25         }
26         ListBox.DataSource = values;
27         ListBox.DataBind();
28         values.Clear();
29         objDataReader.Close();
30         objConnection.Close();
31     }
32     protected void FindData_Click(object sender, EventArgs e)
33     {
34         string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
35         strConnection += Server.MapPath("mydata.mdb");
36         OleDbConnection objConnection = new OleDbConnection(strConnection);
37         objConnection.Open();
38         string m_select;
39         string m_id = Convert.ToString(TBId.Text);
40         m_select = "select*from 通信录 where ID ='" + m_id + "'";
41         OleDbCommand objCommand = new OleDbCommand(m_select, objConnection);
42         OleDbDataReader objDataReader = objCommand.ExecuteReader();
43         while (objDataReader.Read())
44         {
45             TBId.Text = Convert.ToString(objDataReader["ID"]);
46             TBName.Text = Convert.ToString(objDataReader["name"]);
47             TBClass.Text = Convert.ToString(objDataReader["classm"]);
48             TBTelephone.Text = Convert.ToString(objDataReader["telephone"]);
49             TBEmail.Text = Convert.ToString(objDataReader["Email"]);
50             TBAdress.Text = Convert.ToString(objDataReader["Adress"]);
51         }
52         objDataReader.Close();
53         objConnection.Close();
54 
55     }
56     protected void AddData_Click(object sender, EventArgs e)
57     {
58         string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
59         strConnection += Server.MapPath("mydata.mdb");
60         OleDbConnection objConnection = new OleDbConnection(strConnection);
61         string StrInsert;
62         string m_id = Convert.ToString(TBId.Text);
63         string m_name = Convert.ToString(TBName.Text);
64         string m_class = Convert.ToString(TBClass.Text);
65         string m_telephone = Convert.ToString(TBTelephone.Text);
66         string m_email = Convert.ToString(TBEmail.Text);
67         string m_adress = Convert.ToString(TBAdress.Text);
68         StrInsert = "insert into 通信录(ID,name,classm,telephone,Email,Adress)values('" + m_id + "','" + m_name + "','" + m_class + "','" + m_telephone + "','" + m_email + "','" + m_adress + "')";
69         OleDbCommand objCommand = new OleDbCommand(StrInsert, objConnection);
70         objConnection.Open();
71         int a = objCommand.ExecuteNonQuery();
72         objConnection.Close();
73     }
74     protected void UpdateData_Click(object sender, EventArgs e)
75     {
76         string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
77         strConnection += Server.MapPath("mydata.mdb");
78         OleDbConnection objConnection = new OleDbConnection(strConnection);
79         objConnection.Open();
80         string m_update;
81         string m_id = Convert.ToString(TBId.Text);
82         string m_name = Convert.ToString(TBName.Text);
83         m_update = "update 通信录 set name='" + m_name + "'where ID='" + m_id + "'";
84         OleDbCommand objCommand = new OleDbCommand(m_update, objConnection);
85 
86         OleDbDataReader objDataReader = objCommand.ExecuteReader();
87         objDataReader.Close();
88         objConnection.Close();
89     }
90