public static int SuaThiSinh(DTO.ThiSinh ts, string msts) { string cmd = "EXEC SuaThiSinh '" + msts + "','" + ts.MsThiSinh + "',N'" + ts.Ho + "',N'" + ts.Ten + "','" + ts.NgaySinh + "'," + ts.GioiTinh + ",N'" + ts.QuocTich + "',N'" + ts.DiaChi + "','" + ts.HinhAnh + "','" + ts.CMND + "'"; return(ConnectDB.ExecuteNonQuery(cmd)); }
public static int AddQuestion4DA(DTO.CauHoi4DA ch) { string cmd = "EXEC Nhapcauuhoi4dapan '" + ch.Cauhoi + "','" + ch.MsChuDe + "',N'" + ch.DapAn1 + "',N'" + ch.DapAn2 + "',N'" + ch.DapAn3 + "',N'" + ch.DapAn4 + "','" + ch.DA1right + "','" + ch.DA2right + "','" + ch.DA3right + "','" + ch.DA4right + "'"; return(ConnectDB.ExecuteNonQuery(cmd)); }
public static int UpdateXacNhan(String str, String SBD) { string cmd = "UPDATE ThiSinh SET PhanHoi='" + str + "' WHERE MsThiSinh='" + SBD + "'"; return(ConnectDB.ExecuteNonQuery(cmd)); }