public static void UpdateL(tblLop gv) { SqlConnection Conn = dbConnectionData.ketnoi(); SqlCommand command = new SqlCommand("pr_Lop_Update", Conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@MaLop", SqlDbType.NVarChar, 10); command.Parameters.Add("@TenLop", SqlDbType.NVarChar, 100); command.Parameters.Add("@SiSo", SqlDbType.Int, 10); command.Parameters.Add("@MaKhoa", SqlDbType.NVarChar, 10); command.Parameters.Add("@NienKhoa", SqlDbType.NVarChar, 100); command.Parameters["@MaLop"].Value = gv.MaLop1; command.Parameters["@TenLop"].Value = gv.TenLop1; command.Parameters["@SiSo"].Value = gv.SiSo1; command.Parameters["@MaKhoa"].Value = gv.MaKhoa1; command.Parameters["@NienKhoa"].Value = gv.NienKhoa1; Conn.Open(); command.ExecuteNonQuery(); Conn.Close(); }
public static void UpdateLop(tblLop gv) { dalLop.UpdateL(gv); }
public static void InsertLop(tblLop gv) { dalLop.InsertL(gv); }