01.private void btnadd_Click(object sender, EventArgs e)
02. {
03.
04.
05. string leave_id = "";
06. string leave_typename = "";
07. string leave_start = "";
08. string leave_stop = "";
09. string leave_sumtime = "";
10. string employee_ID = "";
11.
12.
13. try
14. {
15.
16. for (int i = 0; i < gridView1.DataRowCount; i++)
17. {
18. leave_id = Convert.ToString(gridView1.GetRowCellValue(i, "leave_id"));
19. leave_typename = Convert.ToString(gridView1.GetRowCellValue(i, "leave_typename"));
20. leave_start = Convert.ToString(gridView1.GetRowCellValue(i,"leave_start"));
21. leave_stop = Convert.ToString(gridView1.GetRowCellValue(i, "leave_stop"));
22. leave_sumtime = Convert.ToString(gridView1.GetRowCellValue(i, "leave_sumtime"));
23. employee_ID = Convert.ToString(gridView1.GetRowCellValue(i, "employee_ID"));
24.
25.
26. }
27.
28. string sqluser = "INSERT INTO tbl_Leave(leave_typename,leave_start,leave_stop,leave_sumtime,employee_ID) VALUES('" + leave_typename + "','" +leave_start+ "','" + leave_stop + "','" + leave_sumtime + "','" + employee_ID + "')";
29. connect_db.ExcuteData(sqluser);
30. showdgvmainleave();
31. MessageBox.Show("บันทึกข้อมูล สำเร็จ !");
32. }
33. catch (Exception ex)
34. {
35. MessageBox.Show(ex.ToString());
36. }
37. }
