public void addExpertise(Expertise xp) { string sql = "INSERT INTO expertise (xp) VALUES ('" + xp.getXp() + "');"; connection.Open(); SQLiteCommand command = new SQLiteCommand(sql, connection); command.ExecuteNonQuery(); connection.Close(); }
public void updateExpertise(Expertise xp) { string sql = "UPDATE expertise SET xp = '" + xp.getXp() + "' WHERE id = " + xp.getId() + ";"; connection.Open(); SQLiteCommand command = new SQLiteCommand(sql, connection); command.ExecuteNonQuery(); connection.Close(); }