SADataAdapter constructors

Initializes a new instance of the SADataAdapter class.

 AcceptChangesDuringFill (inherited from DataAdapter)

Gets or sets a value indicating whether  DataRow.AcceptChanges is called on a  DataRow after it is added to the  DataTable during any of the Fill operations.

 AcceptChangesDuringUpdate (inherited from DataAdapter)

Gets or sets whether  DataRow.AcceptChanges is called during a  DataAdapter.Update.

 ContinueUpdateOnError (inherited from DataAdapter)

Gets or sets a value that specifies whether to generate an exception when an error is encountered during a row update.

DeleteCommand property

Specifies an SACommand object that is executed against the database when the Update method is called to delete rows in the database that correspond to deleted rows in the DataSet.

 FillLoadOption (inherited from DataAdapter)

Gets or sets the  LoadOption that determines how the adapter fills the  DataTable from the  DbDataReader.

InsertCommand property

Specifies an SACommand that is executed against the database when the Update method is called that adds rows to the database to correspond to rows that were inserted in the DataSet.

 MissingMappingAction (inherited from DataAdapter)

Determines the action to take when incoming data does not have a matching table or column.

 MissingSchemaAction (inherited from DataAdapter)

Determines the action to take when existing  DataSet schema does not match incoming data.

 ReturnProviderSpecificTypes (inherited from DataAdapter)

Gets or sets whether the Fill method should return provider-specific values or common CLS-compliant values.

SelectCommand property

Specifies an SACommand that is used during Fill or FillSchema to obtain a result set from the database for copying into a DataSet.

TableMappings property

Specifies a collection that provides the master mapping between a source table and a DataTable.

UpdateBatchSize property

Gets or sets the number of rows that are processed in each round-trip to the server.

UpdateCommand property

Specifies an SACommand that is executed against the database when the Update method is called to update rows in the database that correspond to updated rows in the DataSet.

 Fill (inherited from DbDataAdapter)

Adds or refreshes rows in the  DataSet.

 FillSchema (inherited from DbDataAdapter)

Adds a  DataTable named "Table" to the specified  DataSet and configures the schema to match that in the data source based on the specified  SchemaType.

GetFillParameters method

Returns the parameters set by you when executing a SELECT statement.

 ResetFillLoadOption (inherited from DataAdapter)

Resets  DataAdapter.FillLoadOption to its default state and causes  DataAdapter.Fill to honor  DataAdapter.AcceptChangesDuringFill.

 ShouldSerializeAcceptChangesDuringFill (inherited from DataAdapter)

Determines whether the  DataAdapter.AcceptChangesDuringFill should be persisted.

 ShouldSerializeFillLoadOption (inherited from DataAdapter)

Determines whether the  DataAdapter.FillLoadOption should be persisted.

 Update (inherited from DbDataAdapter)

Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified array of  DataRow objects.

 FillError (inherited from DataAdapter)

Returned when an error occurs during a fill operation.

RowUpdated event

Occurs during an update after a command is executed against the data source. When an attempt to update is made, the event fires.

RowUpdating event

Occurs during an update before a command is executed against the data source. When an attempt to update is made, the event fires.