Пример #1
0
        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));
        }
Пример #2
0
        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));
        }
Пример #3
0
        public static int UpdateXacNhan(String str, String SBD)
        {
            string cmd = "UPDATE ThiSinh SET PhanHoi='" + str + "' WHERE MsThiSinh='" + SBD + "'";

            return(ConnectDB.ExecuteNonQuery(cmd));
        }