MySqlCommand Constructor (String)

MySQL Connector.Net

previous page next page
Collapse image Expand Image Copy image CopyHover image
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.8.4.0

Syntax

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

Parameters

cmdText
Type: System..::..String
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.
Visual Basic Copy imageCopy
Public Sub CreateMySqlCommand()
Dim sql as String = "SELECT * FROM mytable"
Dim myCommand As New MySqlCommand(sql)
myCommand.CommandType = CommandType.Text
End Sub
C# Copy imageCopy
public void CreateMySqlCommand()
{
string sql = "SELECT * FROM mytable";
MySqlCommand myCommand = new MySqlCommand(sql);
myCommand.CommandType = CommandType.Text;
}

See Also

previous page start next page