Represents a set of commands and a database connection used to fill a System.Data.DataSet and to update a database.
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 |
---|---|
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. |
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. |
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. |
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. | |
Specifies an SACommand that is used during Fill or FillSchema to obtain a result set from the database for copying into a DataSet. | |
Specifies a collection that provides the master mapping between a source table and a DataTable. | |
Gets or sets the number of rows that are processed in each round-trip to the server. | |
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. | |
Occurs during an update after a command is executed against the data source. | |
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 Accessing and manipulating data.
SADataAdapter constructor
GetFillParameters method
DeleteCommand property
InsertCommand property
SelectCommand property
TableMappings property
UpdateBatchSize property
UpdateCommand property
RowUpdated event
RowUpdating event
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |