documentation.help

MySqlCommand Constructor (String)

From MySQL Connector/Net

previous page next page
MySqlCommand Constructor (String)
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
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.
PropertiesInitial Value
CommandTextcmdText
CommandTimeout0
CommandTypeCommandType.Text
ConnectionNull

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()
{
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.

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

See Also
previous page start next page