/// <summary> /// Update a Department /// </summary> /// <param name="dept">The updated Department</param> private void updateDept(Department dept) { string sql; sql = "Update Department Dept_Name="; sql += "'" + dept.getName() + "'"; excuteNonQuery(sql); }
/// <summary> /// Insert a department into the database /// </summary> /// <param name="dept">The Department to be inserted</param> private void insertDept(Department dept) { string sql = "INSERT INTO Department VALUES('"+ dept.getName() + "')"; excuteNonQuery(sql); }