public bool sua(SVLopMonHoc sv) { string sql = "update SinhVienLopMonHoc set diemLt = '" + sv.diemLT + "', diemTH = '" + sv.diemTH + "'" + " where maSV = '" + sv.maSV + "' and maLopMonHoc = '" + sv.maLopMonHoc + "'"; return(dal.excuteNonQuery(sql)); }
public bool them(SVLopMonHoc sv) { string sql = "insert into SinhVienLopMonHoc(maSV, maLopMonHoc, diemLT, diemTH)" + " values (N'" + sv.maSV + "', N'" + sv.maLopMonHoc + "', '" + sv.diemLT + "', '" + sv.diemTH + "')"; return(dal.excuteNonQuery(sql)); }