MySqlDataAdapter Members

MySQL Connector.Net

previous page next page
Collapse image Expand Image Copy image CopyHover image

The MySqlDataAdapter type exposes the following members.

Constructors

  Name Description
Public method MySqlDataAdapter()()()()
Initializes a new instance of the MySqlDataAdapter class.
Public method MySqlDataAdapter(MySqlCommand)
Initializes a new instance of the MySqlDataAdapter class with the specified MySqlCommand as the SelectCommand property.
Public method MySqlDataAdapter(String, MySqlConnection)
Initializes a new instance of the MySqlDataAdapter class with a SelectCommand and a MySqlConnection object.
Public method MySqlDataAdapter(String, String)
Initializes a new instance of the MySqlDataAdapter class with a SelectCommand and a connection string.

Methods

  Name Description
Protected method AddToBatch (Overrides DbDataAdapter..::..AddToBatch(IDbCommand).)
Protected method ClearBatch (Overrides DbDataAdapter..::..ClearBatch()()()().)
Protected method CloneInternals Obsolete.
Creates a copy of this instance of DataAdapter.
(Inherited from DataAdapter.)
Public method CreateObjRef
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
(Inherited from MarshalByRefObject.)
Protected method CreateRowUpdatedEvent
Overridden. See CreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping).
(Overrides DbDataAdapter..::..CreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping).)
Protected method CreateRowUpdatingEvent
Overridden. See CreateRowUpdatingEvent(DataRow, IDbCommand, StatementType, DataTableMapping).
(Overrides DbDataAdapter..::..CreateRowUpdatingEvent(DataRow, IDbCommand, StatementType, DataTableMapping).)
Protected method CreateTableMappings
Creates a new DataTableMappingCollection.
(Inherited from DataAdapter.)
Public method Dispose()()()()
Releases all resources used by the Component.
(Inherited from Component.)
Protected method Dispose(Boolean)
Releases the unmanaged resources used by the DbDataAdapter and optionally releases the managed resources.
(Inherited from DbDataAdapter.)
Public method Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected method ExecuteBatch (Overrides DbDataAdapter..::..ExecuteBatch()()()().)
Public method Fill(DataSet)
Adds or refreshes rows in the DataSet.
(Inherited from DbDataAdapter.)
Public method Fill(DataTable)
Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataTable name.
(Inherited from DbDataAdapter.)
Public method Fill(DataSet, String)
Adds or refreshes rows in the DataSet to match those in the data source using the DataSet and DataTable names.
(Inherited from DbDataAdapter.)
Protected method Fill(DataTable, IDataReader)
Adds or refreshes rows in the DataTable to match those in the data source using the DataTable name and the specified IDataReader.
(Inherited from DataAdapter.)
Public method Fill(Int32, Int32, array<DataTable>[]()[][])
Adds or refreshes rows in a DataTable to match those in the data source starting at the specified record and retrieving up to the specified maximum number of records.
(Inherited from DbDataAdapter.)
Protected method Fill(DataTable, IDbCommand, CommandBehavior)
Adds or refreshes rows in a DataTable to match those in the data source using the specified DataTable, IDbCommand and CommandBehavior.
(Inherited from DbDataAdapter.)
Public method Fill(DataSet, Int32, Int32, String)
Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataSet and DataTable names.
(Inherited from DbDataAdapter.)
Protected method Fill(array<DataTable>[]()[][], IDataReader, Int32, Int32)
Adds or refreshes rows in a specified range in the collection of DataTable objects to match those in the data source.
(Inherited from DataAdapter.)
Protected method Fill(array<DataTable>[]()[][], Int32, Int32, IDbCommand, CommandBehavior)
Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataSet and DataTable names.
(Inherited from DbDataAdapter.)
Protected method Fill(DataSet, String, IDataReader, Int32, Int32)
Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataSet and DataTable names.
(Inherited from DataAdapter.)
Protected method Fill(DataSet, Int32, Int32, String, IDbCommand, CommandBehavior)
Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataSet and source table names, command string, and command behavior.
(Inherited from DbDataAdapter.)
Public method FillAsync(DataSet)
Async version of Fill
Public method FillAsync(DataTable)
Async version of Fill
Public method FillAsync(DataSet, String)
Async version of Fill
Public method FillAsync(DataTable, IDataReader)
Async version of Fill
Public method FillAsync(DataTable, IDbCommand, CommandBehavior)
Async version of Fill
Public method FillAsync(Int32, Int32, array<DataTable>[]()[][])
Async version of Fill
Public method FillAsync(DataSet, Int32, Int32, String)
Async version of Fill
Public method FillAsync(DataSet, String, IDataReader, Int32, Int32)
Async version of Fill
Public method FillAsync(array<DataTable>[]()[][], Int32, Int32, IDbCommand, CommandBehavior)
Async version of Fill
Public method FillAsync(DataSet, Int32, Int32, String, IDbCommand, CommandBehavior)
Async version of Fill
Public method FillSchema(DataTable, SchemaType)
Configures the schema of the specified DataTable based on the specified SchemaType.
(Inherited from DbDataAdapter.)
Public method FillSchema(DataSet, SchemaType)
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.
(Inherited from DbDataAdapter.)
Public method FillSchema(DataSet, SchemaType, String)
Adds a DataTable to the specified DataSet and configures the schema to match that in the data source based upon the specified SchemaType and DataTable.
(Inherited from DbDataAdapter.)
Protected method FillSchema(DataTable, SchemaType, IDataReader)
Adds a DataTable to the specified DataSet.
(Inherited from DataAdapter.)
Protected method FillSchema(DataTable, SchemaType, IDbCommand, CommandBehavior)
Configures the schema of the specified DataTable based on the specified SchemaType, command string, and CommandBehavior values.
(Inherited from DbDataAdapter.)
Protected method FillSchema(DataSet, SchemaType, String, IDataReader)
Adds a DataTable to the specified DataSet.
(Inherited from DataAdapter.)
Protected method FillSchema(DataSet, SchemaType, IDbCommand, String, CommandBehavior)
Adds a DataTable to the specified DataSet and configures the schema to match that in the data source based on the specified SchemaType.
(Inherited from DbDataAdapter.)
Public method FillSchemaAsync(DataSet, SchemaType)
Async version of FillSchema
Public method FillSchemaAsync(DataTable, SchemaType)
Async version of FillSchema
Public method FillSchemaAsync(DataSet, SchemaType, String)
Async version of FillSchema
Public method FillSchemaAsync(DataTable, SchemaType, IDataReader)
Async version of FillSchema
Public method FillSchemaAsync(DataSet, SchemaType, String, IDataReader)
Async version of FillSchema
Public method FillSchemaAsync(DataTable, SchemaType, IDbCommand, CommandBehavior)
Async version of FillSchema
Public method FillSchemaAsync(DataSet, SchemaType, IDbCommand, String, CommandBehavior)
Async version of FillSchema
Protected method Finalize
Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection.
(Inherited from Component.)
Protected method GetBatchedParameter (Overrides DbDataAdapter..::..GetBatchedParameter(Int32, Int32).)
Protected method GetBatchedRecordsAffected
Returns information about an individual update attempt within a larger batched update.
(Inherited from DbDataAdapter.)
Public method GetFillParameters
Gets the parameters set by the user when executing an SQL SELECT statement.
(Inherited from DbDataAdapter.)
Public method GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public method GetLifetimeService
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Protected method GetService
Returns an object that represents a service provided by the Component or by its Container.
(Inherited from Component.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected method HasTableMappings
Indicates whether a DataTableMappingCollection has been created.
(Inherited from DataAdapter.)
Protected method InitializeBatching (Overrides DbDataAdapter..::..InitializeBatching()()()().)
Public method InitializeLifetimeService
Obtains a lifetime service object to control the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Protected method MemberwiseClone()()()()
Creates a shallow copy of the current Object.
(Inherited from Object.)
Protected method MemberwiseClone(Boolean)
Creates a shallow copy of the current MarshalByRefObject object.
(Inherited from MarshalByRefObject.)
Protected method OnFillError
Invoked when an error occurs during a Fill.
(Inherited from DataAdapter.)
Protected method OnRowUpdated
Overridden. Raises the RowUpdated event.
(Overrides DbDataAdapter..::..OnRowUpdated(RowUpdatedEventArgs).)
Protected method OnRowUpdating
Overridden. Raises the RowUpdating event.
(Overrides DbDataAdapter..::..OnRowUpdating(RowUpdatingEventArgs).)
Public method ResetFillLoadOption
Resets FillLoadOption to its default state and causes Fill(DataSet) to honor AcceptChangesDuringFill.
(Inherited from DataAdapter.)
Public method ShouldSerializeAcceptChangesDuringFill
Determines whether the AcceptChangesDuringFill property should be persisted.
(Inherited from DataAdapter.)
Public method ShouldSerializeFillLoadOption
Determines whether the FillLoadOption property should be persisted.
(Inherited from DataAdapter.)
Protected method ShouldSerializeTableMappings
Determines whether one or more DataTableMapping objects exist and they should be persisted.
(Inherited from DataAdapter.)
Protected method TerminateBatching (Overrides DbDataAdapter..::..TerminateBatching()()()().)
Public method ToString
Returns a String containing the name of the Component, if any. This method should not be overridden.
(Inherited from Component.)
Public method Update(DataSet)
Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified DataSet.
(Inherited from DbDataAdapter.)
Public method Update(array<DataRow>[]()[][])
Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified array of DataRow objects.
(Inherited from DbDataAdapter.)
Public method Update(DataTable)
Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified DataTable.
(Inherited from DbDataAdapter.)
Public method Update(DataSet, String)
Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the DataSet with the specified DataTable name.
(Inherited from DbDataAdapter.)
Protected method Update(array<DataRow>[]()[][], DataTableMapping) (Overrides DbDataAdapter..::..Update(array<DataRow>[]()[][], DataTableMapping).)
Public method UpdateAsync(array<DataRow>[]()[][])
Async version of Update
Public method UpdateAsync(DataSet)
Async version of Update
Public method UpdateAsync(DataTable)
Async version of Update
Public method UpdateAsync(array<DataRow>[]()[][], DataTableMapping)
Async version of Update
Public method UpdateAsync(DataSet, String)
Async version of Update

Properties

  Name Description
Public property AcceptChangesDuringFill
Gets or sets a value indicating whether AcceptChanges()()()() is called on a DataRow after it is added to the DataTable during any of the Fill operations.
(Inherited from DataAdapter.)
Public property AcceptChangesDuringUpdate
Gets or sets whether AcceptChanges()()()() is called during a Update(DataSet).
(Inherited from DataAdapter.)
Protected property CanRaiseEvents
Gets a value indicating whether the component can raise an event.
(Inherited from Component.)
Public property Container
Gets the IContainer that contains the Component.
(Inherited from Component.)
Public property ContinueUpdateOnError
Gets or sets a value that specifies whether to generate an exception when an error is encountered during a row update.
(Inherited from DataAdapter.)
Public property DeleteCommand
Gets or sets a SQL statement or stored procedure used to delete records from the data set.
Protected property DesignMode
Gets a value that indicates whether the Component is currently in design mode.
(Inherited from Component.)
Protected property Events
Gets the list of event handlers that are attached to this Component.
(Inherited from Component.)
Protected property FillCommandBehavior
Gets or sets the behavior of the command used to fill the data adapter.
(Inherited from DbDataAdapter.)
Public property FillLoadOption
Gets or sets the LoadOption that determines how the adapter fills the DataTable from the DbDataReader.
(Inherited from DataAdapter.)
Public property InsertCommand
Gets or sets a SQL statement or stored procedure used to insert records into the data set.
Public property MissingMappingAction
Determines the action to take when incoming data does not have a matching table or column.
(Inherited from DataAdapter.)
Public property MissingSchemaAction
Determines the action to take when existing DataSet schema does not match incoming data.
(Inherited from DataAdapter.)
Public property ReturnProviderSpecificTypes
Gets or sets whether the Fill method should return provider-specific values or common CLS-compliant values.
(Inherited from DataAdapter.)
Public property SelectCommand
Gets or sets a SQL statement or stored procedure used to select records in the data source.
Public property Site
Gets or sets the ISite of the Component.
(Inherited from Component.)
Public property TableMappings
Gets a collection that provides the master mapping between a source table and a DataTable.
(Inherited from DataAdapter.)
Public property UpdateBatchSize (Overrides DbDataAdapter..::..UpdateBatchSize.)
Public property UpdateCommand
Gets or sets a SQL statement or stored procedure used to updated records in the data source.

Events

  Name Description
Public event Disposed
Occurs when the component is disposed by a call to the Dispose()()()() method.
(Inherited from Component.)
Public event FillError
Returned when an error occurs during a fill operation.
(Inherited from DataAdapter.)
Public event RowUpdated
Occurs during Update after a command is executed against the data source. The attempt to update is made, so the event fires.
Public event RowUpdating
Occurs during Update before a command is executed against the data source. The attempt to update is made, so the event fires.

See Also

previous page start next page