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);
}
