MySqlCommand Constructor (String)

MySQL Connector/Net

previous page next page

MySQL Connector/Net

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

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

Syntax

C++

Copy

public MySqlCommand(
	string cmdText
)

Public Sub New ( 
	cmdText As String
)

public:
MySqlCommand(
	String^ cmdText
)

new : 
        cmdText : string -> MySqlCommand

Parameters

cmdText: Type: SystemString
The text of the query.

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	Null

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.

C++

Copy

public void CreateMySqlCommand()
{
string sql = "SELECT * FROM mytable";
MySqlCommand myCommand = new MySqlCommand(sql);
myCommand.CommandType = CommandType.Text;
}

Public Sub CreateMySqlCommand()
Dim sql as String = "SELECT * FROM mytable"
Dim myCommand As New MySqlCommand(sql)
myCommand.CommandType = CommandType.Text
End Sub

No code example is currently available or this language may not be supported.

Reference

MySqlCommand Class

MySqlCommand Overload

MySql.Data.MySqlClient Namespace

Send comments on this topic to [email protected]

previous page start next page