Query text incorporated into SQL command. Message confirming unsuccessful database connection.Ĭonsole.WriteLine('Database connection unsuccessful.') Message confirming incorrect database location.Ĭonsole.WriteLine('Error locating database.') Ĭonnect = new SqliteConnection('Data Source=' + database + ' ' +

The declaration and execution of the SQL statement is wrapped in a ‘try-catch-finally’ block to catch any errors that may arise and close the database connection at the end. The SQL statement is then executed and a confirmation message is displayed. The other parameters are for updating the ‘lastname’ and ‘title’ fields against the record. One of the parameters is for an ‘id’, so that only the specified record is updated, in this case, the record with an ‘id’ of five. If successfully found, a connection to the database is established, then the query parameters are defined as variables, which are bound in to the SQL statement. If it doesn’t, a message is displayed and execution of the program is halted. Firstly, a check is made to see if the database file actually exists. Updating data follows the same pattern as inserting data. The following example updates the record in the ‘person’ table that was added in the example for inserting data. In order to update data in an SQLite database, the SQL ‘Update’ statement needs to be used.

Sqlite update value