01.private void saceCustomer_Click(object sender, EventArgs e)
02. {
03. OleDbConnection OleDbConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=SparesStore.mdb;");
04. OleDbCommand OleDbCmd = new OleDbCommand();
05. OleDbCmd.Connection = OleDbConn;
06. OleDbCmd.CommandText = "INSERT INTO Customer VALUES (customer_id, customer_name, id_card, address, delivery_adress, telephone, mobile, fax, email, customer_type)";
07. OleDbConn.Open();
08. OleDbCmd.Parameters.Add("@รหัสลูกค้า", OleDbType.VarChar).Value = customer_id.Text;
09. OleDbCmd.Parameters.Add("@ชื่อ", OleDbType.VarChar).Value = customer_name.Text;
10. OleDbCmd.Parameters.Add("@เลที่บัตรประชาชน", OleDbType.VarChar).Value = id_card.Text;
11. OleDbCmd.Parameters.Add("@ที่อยู่", OleDbType.Date).Value = address.Text;
12. OleDbCmd.Parameters.Add("@สถานที่จัดส่ง", OleDbType.VarChar).Value = delivery_adress.Text;
13. OleDbCmd.Parameters.Add("@โทรศัพท์", OleDbType.VarChar).Value = telephone.Text;
14. OleDbCmd.Parameters.Add("@มือถือ", OleDbType.VarChar).Value = mobile.Text;
15. OleDbCmd.Parameters.Add("@แฟกซ์", OleDbType.VarChar).Value = fax.Text;
16. OleDbCmd.Parameters.Add("@Email", OleDbType.VarChar).Value = email.Text;
17. OleDbCmd.Parameters.Add("@ประเภทลูกค้า", OleDbType.VarChar).Value = customer_type.Text;
18. OleDbCmd.ExecuteNonQuery();
19. OleDbConn.Close();
20. MessageBox.Show("บันทึกสำเร็จ");
21. }
Quote:
