MySqlDataAdapter Methods

MySQL Connector.Net

Collapse image Expand Image Copy image CopyHover image

The MySqlDataAdapter type exposes the following members.

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 (Overrides DbDataAdapter..::..CreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping).)
Protected method CreateRowUpdatingEvent (Overrides DbDataAdapter..::..CreateRowUpdatingEvent(DataRow, IDbCommand, StatementType, DataTableMapping).)
Protected method CreateTableMappings (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

See Also