public void DeleteDiem(string MaSV, string maMon, string dgk, string dck) { QLSVDataContext qLSV = new QLSVDataContext(); string sqlString = string.Format("Delete From KetQua Where maSV=N'{0}' and maMon=N'{1}' and diemGiuaKi={2} and diemCuoiKi={3}", MaSV, maMon, dgk, dck); qLSV.ExecuteQuery <KetQua>(sqlString); }
public void UpdateDiem(string maSV, string maMon, string dgkc, string dckc, string dgk, string dck, string dtb, string kq) { QLSVDataContext qLSV = new QLSVDataContext(); string sqlString = string.Format("Update KetQua SET diemGiuaKi='{4}',diemCuoiKi='{5}',diemTB='{6}',ketQua='{7}' where maSV=N'{0}' and maMon=N'{1}' and diemGiuaKi='{2}' and diemCuoiKi='{3}'", maSV, maMon, dgkc, dckc, dgk, dck, dtb, kq); qLSV.ExecuteQuery <KetQua>(sqlString); }
public void InsertDiem(string maSV, string maMon, string dgk, string dck, string dtb, string kq) { QLSVDataContext qLSV = new QLSVDataContext(); string sqlString = string.Format("Insert KetQua (maSV,maMon,diemGiuaKi,diemCuoiKi,diemTB,ketQua)" + "VALUES(N'{0}',N'{1}',{2},{3},{4},N'{5}')", maSV, maMon, dgk, dck, dtb, kq); qLSV.ExecuteQuery <KetQua>(sqlString); }