MySqlSharp.Provider
Class MySqlDataAdapter

Represents a set of data commands and a database connection that are used to fill the System.Data.DataSet and update a mySQL database.

The MySqlSharp.Provider.MySqlDataAdapter, serves as a bridge between a System.Data.DataSet and mySQL for retrieving and saving data. The MySqlSharp.Provider.MySqlDataAdapter provides this bridge by mapping System.Data.IDataAdapter.Fill(System.Data.DataSet), which changes the data in the System.Data.DataSet to match the data in the data source, and System.Data.IDataAdapter.Update(System.Data.DataSet), which changes the data in the data source to match the data in the System.Data.DataSet, using the appropriate mySQL statements against the data source.

MySqlDataAdapter

public MySqlDataAdapter()

Initializes a new instance of the MySqlSharp.Provider.MySqlDataAdapter class.

MySqlDataAdapter

public MySqlDataAdapter(MySqlSharp.Provider.MySqlCommand selectCommand)

Initializes a new instance of the MySqlSharp.Provider.MySqlDataAdapter class with the specified MySqlSharp.Provider.MySqlCommand as the MySqlSharp.Provider.MySqlDataAdapter.SelectCommand property.

Parameters:

selectCommand - A MySqlSharp.Provider.MySqlCommand that is a mySQL SELECT statement or stored procedure. This MySqlSharp.Provider.MySqlCommand is set as the MySqlSharp.Provider.MySqlDataAdapter.SelectCommand property of the MySqlSharp.Provider.MySqlDataAdapter.

MySqlDataAdapter

public MySqlDataAdapter(string selectCommandText,
                        string selectConnectionString)

Initializes a new instance of the MySqlSharp.Provider.MySqlDataAdapter class with a MySqlSharp.Provider.MySqlDataAdapter.SelectCommand and a connection string.

Parameters:

selectCommandText - A String that is a mySQL SELECT statement or stored procedure to be used as the MySqlSharp.Provider.MySqlCommand.CommandText of the MySqlSharp.Provider.MySqlDataAdapter.SelectCommand property of the MySqlSharp.Provider.MySqlDataAdapter.

selectConnectionString - The connection string.

MySqlDataAdapter

public MySqlDataAdapter(string selectCommandText,
                        MySqlSharp.Provider.MySqlConnection selectConnection)

Inintializes a new instance of the MySqlSharp.Provider.MySqlDataAdapter class with a MySqlSharp.Provider.MySqlDataAdapter.SelectCommand and a MySqlSharp.Provider.MySqlConnection object.

Parameters:

selectCommandText - A String that is a mySQL SELECT statement or stored procedure to be used as the MySqlSharp.Provider.MySqlCommand.CommandText of the MySqlSharp.Provider.MySqlDataAdapter.SelectCommand property of the MySqlSharp.Provider.MySqlDataAdapter.

selectConnection - A MySqlSharp.Provider.MySqlConnection that represents the connection.

DeleteCommand

public MySqlSharp.Provider.MySqlCommand DeleteCommand

Gets or sets a mySQL statement used to delete records in the data source.

Value:

A MySqlSharp.Provider.MySqlCommand used during System.Data.IDataAdapter.Update(System.Data.DataSet) to delete records in the database that correspond to deleted rows in the System.Data.DataSet.

InsertCommand

public MySqlSharp.Provider.MySqlCommand InsertCommand

Gets or sets a mySQL statement used to insert records in the data source.

Value:

A MySqlSharp.Provider.MySqlCommand used during System.Data.IDataAdapter.Update(System.Data.DataSet) to insert records in the database that correspond to added rows in the System.Data.DataSet.

SelectCommand

public MySqlSharp.Provider.MySqlCommand SelectCommand

Gets or sets a mySQL statement used to select records in the data source.

Value:

A MySqlSharp.Provider.MySqlCommand used during System.Data.IDataAdapter.Fill(System.Data.DataSet) to select records from the database for placement in the System.Data.DataSet.

UpdateCommand

public MySqlSharp.Provider.MySqlCommand UpdateCommand

Gets or sets a mySQL statement used to update records in the data source.

Value:

A MySqlSharp.Provider.MySqlCommand used during System.Data.IDataAdapter.Update(System.Data.DataSet) to update records in the database that correspond to modified rows in the System.Data.DataSet.

CreateRowUpdatedEvent

protected System.Data.Common.RowUpdatedEventArgs CreateRowUpdatedEvent(System.Data.DataRow dataRow,
                                                                 System.Data.IDbCommand command,
                                                                 System.Data.StatementType statementType,
                                                                 System.Data.Common.DataTableMapping tableMapping)

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

CreateRowUpdatingEvent

protected System.Data.Common.RowUpdatingEventArgs CreateRowUpdatingEvent(System.Data.DataRow dataRow,
                                                                 System.Data.IDbCommand command,
                                                                 System.Data.StatementType statementType,
                                                                 System.Data.Common.DataTableMapping tableMapping)

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

OnRowUpdated

protected void OnRowUpdated(System.Data.Common.RowUpdatedEventArgs value)

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

OnRowUpdating

protected void OnRowUpdating(System.Data.Common.RowUpdatingEventArgs value)

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

RowUpdated

public MySqlSharp.Provider.MySqlRowUpdatedEventHandler RowUpdated

Occurs during System.Data.IDataAdapter.Update(System.Data.DataSet) after a command is executed against the data source. The attempt to update is made, so the event fires.

RowUpdating

public MySqlSharp.Provider.MySqlRowUpdatingEventHandler RowUpdating

Occurs during System.Data.IDataAdapter.Update(System.Data.DataSet) before a command is executed against the data source. The attempt to update is made, so the event fires.