01.private void butSave_Click(object sender, EventArgs e)
02. {
03.
04. MySqlConnection connection = new MySqlConnection(MyConnectionString);
05. MySqlCommand cmd;
06. connection.Open();
07. cmd = connection.CreateCommand();
08.
09. string[] Start;
10. Start = new string[12];
11. Start[0] = txtStr1.Text.ToString();
12. Start[1] = txtStr2.Text.ToString();
13. Start[2] = txtStr3.Text.ToString();
14. Start[3] = txtStr4.Text.ToString();
15. Start[4] = txtStr5.Text.ToString();
16. Start[5] = txtStr6.Text.ToString();
17. Start[6] = txtStr7.Text.ToString();
18. Start[7] = txtStr8.Text.ToString();
19. Start[8] = txtStr9.Text.ToString();
20. Start[9] = txtStr10.Text.ToString();
21. Start[10] = txtStr11.Text.ToString();
22. Start[11] = txtStr12.Text.ToString();
23.
24.
25. string[] Finish;
26. Finish = new string[12];
27.
28. Finish[0] = txtEnd1.Text.ToString();
29. Finish[1] = txtEnd2.Text.ToString();
30. Finish[2] = txtEnd3.Text.ToString();
31. Finish[3] = txtEnd4.Text.ToString();
32. Finish[4] = txtEnd5.Text.ToString();
33. Finish[5] = txtEnd6.Text.ToString();
34. Finish[6] = txtEnd7.Text.ToString();
35. Finish[7] = txtEnd8.Text.ToString();
36. Finish[8] = txtEnd9.Text.ToString();
37. Finish[9] = txtEnd10.Text.ToString();
38. Finish[10] = txtEnd11.Text.ToString();
39. Finish[11] = txtEnd12.Text.ToString();
40. string[] period_id;
41. period_id = new string[12];
42.
43. period_id[0] = "";
44. period_id[1] = "";
45. period_id[2] = "";
46. period_id[3] = "";
47. period_id[4] = "";
48. period_id[5] = "";
49. period_id[6] = "";
50. period_id[7] = "";
51. period_id[8] = "";
52. period_id[9] = "";
53. period_id[10] = "";
54. period_id[11] = "";
55.
56. for (int k = 0; k < 12; k++)
57. {
58.
59. cmd = connection.CreateCommand();
60. cmd.CommandText = "INSERT INTO tb_period VALUES('',@Start,@Finish)";
61.
62.
63.
64. cmd.Parameters.AddWithValue("@Start", Start[k]);
65. cmd.Parameters.AddWithValue("@Finish", Finish[k]);
66. cmd.ExecuteNonQuery();
67.
68. }
69.
70. MessageBox.Show("คุณได้เพิ่มข้อมูลเรียบร้อยแล้ว");
71. connection.Close();
72.
73. }
74.
75.
76. }
