MySQL Connector/Net
MySqlCommand Constructor (String, MySqlConnection, MySqlTransaction) |
Initializes a new instance of the MySqlCommand class
with the text of the query, a MySqlConnection, and the
MySqlTransaction.
Namespace: MySql.Data.MySqlClient
Assembly: MySql.Data (in MySql.Data.dll) Version: 6.9.9
Syntax
public MySqlCommand( string cmdText, MySqlConnection connection, MySqlTransaction transaction )
Public Sub New ( cmdText As String, connection As MySqlConnection, transaction As MySqlTransaction )
public: MySqlCommand( String^ cmdText, MySqlConnection^ connection, MySqlTransaction^ transaction )
new : cmdText : string * connection : MySqlConnection * transaction : MySqlTransaction -> MySqlCommand
Parameters
- cmdText
- Type: SystemString
The text of the query. - connection
- Type: MySql.Data.MySqlClientMySqlConnection
A MySqlConnection that represents the connection to an instance of SQL Server. - transaction
- Type: MySql.Data.MySqlClientMySqlTransaction
The MySqlTransaction in which the MySqlCommand executes.
Remarks
When an instance of MySqlCommand is created,
the following read/write properties are set to initial values.
Properties | Initial Value |
---|---|
CommandText | cmdText |
CommandTimeout | 0 |
CommandType | CommandType.Text |
Connection | connection |
You can change the value for any of these properties through a separate call to the property.
Examples
The following example creates a MySqlCommand and
sets some of its properties.
public void CreateMySqlCommand() { MySqlConnection conn = new MySqlConnection("server=myserver") conn.Open(); MySqlTransaction txn = conn.BeginTransaction(); string sql = "SELECT * FROM mytable"; MySqlCommand myCommand = new MySqlCommand(sql, conn, txn); myCommand.CommandType = CommandType.Text; }
Public Sub CreateMySqlCommand() Dim conn as new MySqlConnection("server=myServer") conn.Open(); Dim txn as MySqlTransaction = conn.BeginTransaction() Dim sql as String = "SELECT * FROM mytable" Dim myCommand As New MySqlCommand(sql, conn, txn) myCommand.CommandType = CommandType.Text End Sub
No code example is currently available or this language may not be supported.
No code example is currently available or this language may not be supported.
See Also