MySqlCommand Constructor (String, MySqlConnection, MySqlTransaction)

MySQL Connector/Net

previous page next page
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
Copy
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.
PropertiesInitial Value
CommandTextcmdText
CommandTimeout0
CommandTypeCommandType.Text
Connectionconnection

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.
Copy
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
previous page start next page