MySqlCommand Constructor (String, MySqlConnection)

MySQL Connector/Net

Initializes a new instance of the MySqlCommand class with the text of the query and a MySqlConnection.

Namespace:  MySql.Data.MySqlClient
Assembly:  MySql.Data (in MySql.Data.dll) Version: 6.2.2.0

Syntax

C#
public MySqlCommand(
	string cmdText,
	MySqlConnection connection
)
Visual Basic (Declaration)
Public Sub New ( _
	cmdText As String, _
	connection As MySqlConnection _
)
Visual C++
public:
MySqlCommand(
	String^ cmdText, 
	MySqlConnection^ connection
)

Parameters

cmdText
Type: System..::.String
The text of the query.
connection
Type: MySql.Data.MySqlClient..::.MySqlConnection
A MySqlConnection that represents the connection to an instance of SQL Server.

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.
CopyVB.NET
Public Sub CreateMySqlCommand()
Dim conn as new MySqlConnection("server=myServer")
Dim sql as String = "SELECT * FROM mytable"
Dim myCommand As New MySqlCommand(sql, conn)
myCommand.CommandType = CommandType.Text
End Sub
CopyC#
public void CreateMySqlCommand()
{
MySqlConnection conn = new MySqlConnection("server=myserver")
string sql = "SELECT * FROM mytable";
MySqlCommand myCommand = new MySqlCommand(sql, conn);
myCommand.CommandType = CommandType.Text;
}

See Also