Updating Data

This section provides general guidelines to help you to optimize system performance when updating data in databases.

Using the Disconnected DataSet

Keep result sets small. The full result set must be retrieved from the server before the DataSet is populated. The full result set is stored in memory on the client.

Synchronizing Changes Back to the Data Source

You must build the logic into the PsqlDataAdapter for synchronizing the changes back to the data source using the primary key, as shown in the following example:

string updateSQL As String = "UPDATE emp SET sal = ?, job = ?" +
" = WHERE empno = ?";