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
|
请发表评论