01.protected void Edit_data()
02. {
03.
04. string strConn;
05. strConn = WebConfigurationManager.ConnectionStrings["GAS_CYLINDERConnectionString1"].ConnectionString;
06. SqlConnection Conn = new SqlConnection(strConn);
07. Conn.Open();
08.
09. StringBuilder sb = new StringBuilder();
10. sb.Append("UPDATE Detail");
11. sb.Append("SET Serial_no=@Serial_no,Type=@Type,Supplier=@Supplier,Site=@Site, Location=@Location,Owner=@Owner,Arrival_date=@Arrival_date ,Inspection_date=@Inspection_date,Next_inspection_date=@Next_inspection_date, Overdue_inspection_date=@Overdue_inspection_date, Hydrotest_date=@Hydrotest_date,Next_Hydrotest_date=@Next_Hydrotest_date, Overdue_Hydrotest_date=@Overdue_Hydrotest_date,Note=@Note");
12. sb.Append("WHERE CylinderID=@CylinderID_call");
13. string sqlSave = sb.ToString();
14. SqlCommand com = new SqlCommand(sqlSave, Conn);
15. com.Parameters.Clear();
16. com.Parameters.Add("@Serial_no", SqlDbType.NVarChar).Value = Tserialno.Text;
17. com.Parameters.Add("@Type", SqlDbType.NVarChar).Value = Ttype.Text;
18. com.Parameters.Add("@Supplier", SqlDbType.NVarChar).Value = Tsupplier.Text;
19. com.Parameters.Add("@Site", SqlDbType.NVarChar).Value = Dsite.Text;
20. com.Parameters.Add("@Location", SqlDbType.NVarChar).Value = Tlocation.Text;
21. com.Parameters.Add("@Owner", SqlDbType.NVarChar).Value = Downer.Text;
22. com.Parameters.Add("@Arrival_date", SqlDbType.NVarChar).Value = Ttoaqp.Text;
23. com.Parameters.Add("@Inspection_date", SqlDbType.NVarChar).Value = Tinspecdate.Text;
24. com.Parameters.Add("@Next_inspection_date", SqlDbType.NVarChar).Value = Tinspecnext.Text;
25. com.Parameters.Add("@Overdue_inspection_date", SqlDbType.NVarChar).Value = Toverinspecnext.Text;
26. com.Parameters.Add("@Hydrotest_date", SqlDbType.NVarChar).Value = Thydrodate.Text;
27. com.Parameters.Add("@Next_Hydrotest_date", SqlDbType.NVarChar).Value = Tnexthydro.Text;
28. com.Parameters.Add("@Overdue_Hydrotest_date", SqlDbType.NVarChar ).Value = Toverhydro.Text;
29. com.Parameters.Add("@Note", SqlDbType.NVarChar).Value = Tnote.Text;
30. com.Parameters.Add("@CylinderID_call", SqlDbType.Int).Value = Tid.Text;
31.
32. com.ExecuteNonQuery();
33. Conn.Close();
34.
35.
36.
37. }
Quote:
