예제 #1
0
        public bool suaLop(LopCoDinh lop)
        {
            string sql = "update LopCoDinh set tenLopCodinh = N'" + lop.tenLop + "', maKhoa = N'" + lop.maKhoa + "', khoaHoc ='"
                         + lop.khoaHoc + "', maGV = N'" + lop.maGV + "' where maLopCoDinh = N'" + lop.maLop + "'";

            return(dal.excuteNonQuery(sql));
        }
예제 #2
0
        public bool themLop(LopCoDinh lop)
        {
            string sql = "insert into LopCoDinh(maLopCoDinh, tenLopCoDinh, maKhoa, khoaHoc, maGV) values(N'"
                         + lop.maLop + "', N'" + lop.tenLop + "', N'" + lop.maKhoa + "', '"
                         + lop.khoaHoc + "', N'" + lop.maGV + "')";

            return(dal.excuteNonQuery(sql));
        }