SADataAdapter class

Public NotInheritable Class SADataAdapter
    Inherits System.Data.Common.DbDataAdapter
    Implements System.ICloneable

public sealed class SADataAdapter : 
    System.Data.Common.DbDataAdapter, 
    System.ICloneable

All members of SADataAdapter class, including all inherited members.

Name	Description
SADataAdapter constructor	Initializes an SADataAdapter object.
AddToBatch method (Inherited from System.Data.Common.DbDataAdapter)	Adds a System.Data.IDbCommand to the current batch.
CreateRowUpdatedEvent method (Inherited from System.Data.Common.DbDataAdapter)	Initializes a new instance of the System.Data.Common.RowUpdatedEventArgs class.
CreateRowUpdatingEvent method (Inherited from System.Data.Common.DbDataAdapter)	Initializes a new instance of the System.Data.Common.RowUpdatingEventArgs class.
Dispose method (Inherited from System.Data.Common.DbDataAdapter)	Releases the unmanaged resources used by the System.Data.Common.DbDataAdapter and optionally releases the managed resources.
ExecuteBatch method (Inherited from System.Data.Common.DbDataAdapter)	Executes the current batch.
Fill method (Inherited from System.Data.Common.DbDataAdapter)	Adds or refreshes rows in the System.Data.DataSet.
FillSchema method (Inherited from System.Data.Common.DbDataAdapter)	Adds a System.Data.DataTable named "Table" to the specified System.Data.DataSet and configures the schema to match that in the data source based on the specified System.Data.SchemaType.
GetBatchedParameter method (Inherited from System.Data.Common.DbDataAdapter)	Returns a System.Data.IDataParameter from one of the commands in the current batch.
GetBatchedRecordsAffected method (Inherited from System.Data.Common.DbDataAdapter)	Returns information about an individual update attempt within a larger batched update.
GetFillParameters method	Returns the parameters set by you when executing a SELECT statement.
FillError (Inherited from System.Data.Common.DbDataAdapter) OnFillError method (Inherited from System.Data.Common.DbDataAdapter)
OnRowUpdated method (Inherited from System.Data.Common.DbDataAdapter)	Raises the RowUpdated event of a .NET Framework data provider.
OnRowUpdating method (Inherited from System.Data.Common.DbDataAdapter)	Raises the RowUpdating event of a .NET Framework data provider.
Update method (Inherited from System.Data.Common.DbDataAdapter)	Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified array of System.Data.DataRow objects.
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.
FillCommandBehavior property (Inherited from System.Data.Common.DbDataAdapter)	Gets or sets the behavior of the command used to fill the data adapter.
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.
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.
RowUpdated event	Occurs during an update after a command is executed against the data source.
RowUpdating event	Occurs during an update before a command is executed against the data source.

The System.Data.DataSet provides a way to work with data offline. The SADataAdapter provides methods to associate a DataSet with a set of SQL statements.

Implements: IDbDataAdapter, IDataAdapter, ICloneable

For more information, see Using the SADataAdapter object to access and manipulate data and Data access and manipulation.

SADataAdapter class

Visual Basic syntax

C# syntax

Base classes

Members

Remarks