01.protected void Button1_Click(object sender, EventArgs e)
02. {
03. foreach (GridViewRow row in GridView1.Rows)
04. {
05. var chk = row.FindControl("chkDelete") as CheckBox;
06.
07. if (chk.Checked)
08. {
09. var lblID = row.FindControl("lblID") as Label;
10. var lblMC = row.FindControl("lblMC") as Label;
11. var lblEmployeeID = row.FindControl("lblEmployeeID") as Label;
12. var lblName = row.FindControl("lblName") as Label;
13. var lblLastName = row.FindControl("lblLastName") as Label;
14. var lblDep = row.FindControl("lblDep") as Label;
15. var lblFaction = row.FindControl("lblFaction") as Label;
16. var lblShife = row.FindControl("lblShife") as Label;
17. var lblDay = row.FindControl("lblDay") as Label;
18. var lblTimeStart = row.FindControl("lblTimeStart") as Label;
19. var lblTimeEnd = row.FindControl("lblTimeEnd") as Label;
20. var lblCar = row.FindControl("lblCar") as Label;
21. var lblFood = row.FindControl("lblFood") as Label;
22. var lblRemark = row.FindControl("lblRemark") as Label;
23.
24.
25. SqlCommand comm = new SqlCommand();
26. comm.CommandText = "insert into ApproveGA_HR (id,MC,EmployeeID,Name,LastName,Dep,Faction,Shife,Day,TimeStart,TimeEnd,Car,Food,Remark) Values (@id,@MC,@EmployeeID,@Name,@LastName,@Dep,@Faction,@Shife,@Day,@TimeStart,@TimeEnd,@Car,@Food,@Remark)";
27.
28. comm.Parameters.AddWithValue("@id", int.Parse(lblID.Text));
29. comm.Parameters.AddWithValue("@MC", Convert.ToString(lblMC.Text));
30. comm.Parameters.AddWithValue("@EmployeeID", int.Parse(lblEmployeeID.Text));
31. comm.Parameters.AddWithValue("@Name", Convert.ToString(lblName.Text));
32. comm.Parameters.AddWithValue("@LastName", Convert.ToString(lblLastName.Text));
33. comm.Parameters.AddWithValue("@Dep", Convert.ToString(lblDep.Text));
34. comm.Parameters.AddWithValue("@Faction", Convert.ToString(lblFaction.Text));
35. comm.Parameters.AddWithValue("@Shife", Convert.ToString(lblShife.Text));
36. comm.Parameters.AddWithValue("@Day", Convert.ToString(lblDay.Text));
37. comm.Parameters.AddWithValue("@TimeStart", Convert.ToString(lblTimeStart.Text));
38. comm.Parameters.AddWithValue("@TimeEnd", Convert.ToString(lblTimeEnd.Text));
39. comm.Parameters.AddWithValue("@Car", Convert.ToString(lblCar.Text));
40. comm.Parameters.AddWithValue("@Food", Convert.ToString(lblFood.Text));
41. comm.Parameters.AddWithValue("@Remark", Convert.ToString(lblRemark.Text));
42.
43. comm.Connection = con1;
44.
45.
46.
47. con1.Open();
48.
49. comm.ExecuteNonQuery();
50. con1.Close();
51.
52.
53. }
54. }
55. }
