public void suadulieu(Entity_SinhVien et) { cn.ThucthiSQL(@"UPDATE tblSinhVien SET HoSV =N'" + et.HoSV + "', TenSV =N'" + et.TenSV + "', NgaySinh =N'" + et.NgaySinh + "', GioiTinh =N'" + et.GioiTinh + "', QueQuan =N'" + et.QueQuan + "', MaLop =N'" + et.MaLop + "' where MaSV=N'" + et.MaSV + "'"); }
public void xoadulieu(Entity_SinhVien et) { cn.ThucthiSQL(@"DELETE FROM tblSinhVien where MaSV=N'" + et.MaSV + "'"); }
public void themdulieu(Entity_SinhVien et) { cn.ThucthiSQL(@"INSERT INTO tblSinhVien (MaSV, HoSV, TenSV, NgaySinh, GioiTinh, QueQuan, MaLop) VALUES (N'" + et.MaSV + "',N'" + et.HoSV + "',N'" + et.TenSV + "',N'" + et.NgaySinh + "',N'" + et.GioiTinh + "',N'" + et.QueQuan + "',N'" + et.MaLop + "')"); }