MySqlCommand Members

MySQL Connector/Net

The MySqlCommand type exposes the following members.

Constructors

  Name Description
MySqlCommand Overloaded.
Initializes a new instance of the MySqlCommand class.

Methods

  Name Description
BeginExecuteNonQuery Overloaded.
BeginExecuteReader Overloaded.
Cancel
Attempts to cancel the execution of a currently active command
(Overrides DbCommand..::.Cancel()()().)
Clone
Creates a clone of this MySqlCommand object. CommandText, Connection, and Transaction properties are included as well as the entire parameter list.
CreateDbParameter
Creates a new instance of a DbParameter object.
(Inherited from DbCommand.)
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.)
CreateParameter
Creates a new instance of a MySqlParameter object.
Dispose Overloaded.
EndExecuteNonQuery
Finishes asynchronous execution of a SQL statement.
EndExecuteReader
Finishes asynchronous execution of a SQL statement, returning the requested MySqlDataReader.
Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
ExecuteDbDataReader
Executes the command text against the connection.
(Inherited from DbCommand.)
ExecuteNonQuery
Executes a SQL statement against the connection and returns the number of rows affected.
(Overrides DbCommand..::.ExecuteNonQuery()()().)
ExecuteReader Overloaded.
ExecuteScalar
Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.
(Overrides DbCommand..::.ExecuteScalar()()().)
Finalize
Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection.
(Inherited from Component.)
GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
GetLifetimeService
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
GetService
Returns an object that represents a service provided by the Component or by its Container.
(Inherited from Component.)
GetType
Gets the Type of the current instance.
(Inherited from Object.)
InitializeLifetimeService
Obtains a lifetime service object to control the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
MemberwiseClone Overloaded.
Prepare
Creates a prepared version of the command on an instance of MySQL Server.
(Overrides DbCommand..::.Prepare()()().)
ToString
Returns a String containing the name of the Component, if any. This method should not be overridden.
(Inherited from Component.)

Properties

  Name Description
CanRaiseEvents
Gets a value indicating whether the component can raise an event.
(Inherited from Component.)
CommandText
Gets or sets the SQL statement to execute at the data source.
(Overrides DbCommand..::.CommandText.)
CommandTimeout
Gets or sets the wait time before terminating the attempt to execute a command and generating an error.
(Overrides DbCommand..::.CommandTimeout.)
CommandType
Gets or sets a value indicating how the CommandText property is to be interpreted.
(Overrides DbCommand..::.CommandType.)
Connection
Gets or sets the MySqlConnection used by this instance of the MySqlCommand.
Container
Gets the IContainer that contains the Component.
(Inherited from Component.)
DbConnection
Gets or sets the DbConnection used by this DbCommand.
(Inherited from DbCommand.)
DbParameterCollection
Gets the collection of DbParameter objects.
(Inherited from DbCommand.)
DbTransaction
Gets or sets the DbTransaction within which this DbCommand object executes.
(Inherited from DbCommand.)
DesignMode
Gets a value that indicates whether the Component is currently in design mode.
(Inherited from Component.)
DesignTimeVisible
Gets or sets a value indicating whether the command object should be visible in a Windows Form Designer control.
(Overrides DbCommand..::.DesignTimeVisible.)
Events
Gets the list of event handlers that are attached to this Component.
(Inherited from Component.)
IsPrepared
LastInsertedId
Parameters
Site
Gets or sets the ISite of the Component.
(Inherited from Component.)
Transaction
Gets or sets the MySqlTransaction within which the MySqlCommand executes.
UpdatedRowSource
Gets or sets how command results are applied to the DataRow when used by the Update method of the DbDataAdapter.
(Overrides DbCommand..::.UpdatedRowSource.)

Events

  Name Description
Disposed
Occurs when the component is disposed by a call to the Dispose()()() method.
(Inherited from Component.)

See Also