01.protected void myGridView_RowCommand(object sender, GridViewCommandEventArgs e)
02. {
03.
04.
05.
06. if (e.CommandName == "Update")
07. {
08. SqlConnection conn = new SqlConnection("Server=192.168.0.4;PASSWORD=F@753951;database=ReportHR; User id=sa; ");
09. conn.Open();
10.
11. TextBox log1 = (TextBox)myGridview.FindControl("lbProduct");
12. TextBox log2 = (TextBox)myGridview.FindControl("lbSeatsused");
13. TextBox log3 = (TextBox)myGridview.FindControl("lbSeatsavailable");
14. TextBox log4 = (TextBox)myGridview.FindControl("lbExpired");
15. TextBox log5 = (TextBox)myGridview.FindControl("lbOverdeployed");
16.
17. strSQL = "INSERT INTO log_activity (product,seatsused,seatsavailable,expired,overdeployed) " +
18. " VALUES ('" + log1.Text + "','" + log2.Text + "','" + log3.Text + "' " +
19. " ,'" + log4.Text + "','" + log5.Text + "')";
20.
21. SqlCommand comm = new SqlCommand(strSQL, conn);
22.
23.
24.
25. objCmd = new SqlCommand(strSQL, objConn);
26. objCmd.ExecuteNonQuery();
27.
28. loadData();
29. }
30.
31. }
