public int Insert(MonHocDTO Mh) { string sql = "insert into MONHOC values (@MaMon,@TenMon,@HeSo)"; SqlParameter[] sp = new SqlParameter[3]; sp[0] = new SqlParameter("@MaMon", Mh.MaMon); sp[1] = new SqlParameter("@TenMon", Mh.TenMon); sp[2] = new SqlParameter("@HeSo",Mh.HeSo); return conectData.Insert_Update_Delete(sql, sp); }
public int Update(MonHocDTO Mh) { string sql = "update MONHOC set TenMon=@TenMon,HeSo=@HeSo where MaMon=@MaMon"; SqlParameter[] sp = new SqlParameter[3]; sp[0] = new SqlParameter("@MaMon", Mh.MaMon); sp[1] = new SqlParameter("@TenMon", Mh.TenMon); sp[2] = new SqlParameter("@HeSo", Mh.HeSo); return conectData.Insert_Update_Delete(sql, sp); }