The SqlDataAdapter Class You use an object of the SqlDataAdapter class to synchronize data stored in a DataSet object with a SQL Server database | The SqlDataAdapter Class You use an object of the SqlDataAdapter class to synchronize data stored in a DataSet object with a SQL Server database. You use an object of the OleDbDataAdapter class to synchronize data with a database that supports OLE DB such as Oracle or Access. You use an object of the OdbcDataAdapter class to synchronize data with a database that supports ODBC. Note Although the SqlDataAdapter class is specific to SQL Server many of the properties and methods in this class are the same as those for the OleDbDataAdapter and OdbcDataAdapter classes. Table shows some of the SqlDataAdapter properties. Table SqlDataAdapter PROPERTIES PROPERTY TYPE DESCRIPTION AcceptChangesDuringF ill bool Gets or sets a bool that indicates whether the AcceptChanges method is called after a DataRow object has been added modified or removed in a DataTable object. The default is true. ContinueUpdateOnError bool Gets or sets a bool that indicates whether to continue updating the database when an error occurs. When set to true no exception is thrown when an error occurs during the update of a row. The update of the row is skipped and the error information is placed in the RowError property of the DataRow that caused the error. The DataAdapter continues to update subsequent rows. When set to false an exception is thrown when an error occurs. The default is false. DeleteCommand SqlCommand Gets or sets a command containing Table SqlDataAdapter PROPERTIES PROPERTY TYPE DESCRIPTION a SQL DELETE statement or stored procedure call to remove rows from the database. InsertCommand SqlCommand Gets or sets a command containing a SQL INSERT statement or stored procedure call to add rows to the database. MissingMappingAction MissingMappingAction Gets or sets the action to take when the incoming table or column doesn t have a matching table or column in the TableMappings collection. The values for this action come from the on enumeration with .
