CommandType Property (MySqlCommand)

In This Topic

Syntax
Remarks
Example
See Also

Gets or sets a value indicating how the CommandText property is to be interpreted.

Syntax

Visual Basic
C#

public override CommandType CommandType {get; set;}

'Declaration
 
Public Overrides Property CommandType As CommandType

Property Value

One of the System.Data.CommandType values. The default value is System.Data.CommandType.Text.

Remarks

CommandType can be one of the following values: Text, StoredProcedure, TableDirect.

When the value is CommandType.Text, the property CommandText should contain text of a query that must be run on the server.

When the value is CommandType.StoredProcedure, CommandText property must be a name of a procedure to execute. This is supported only for MySQL 5.0 and newer versions.

When the value is set to TableDirect, CommandText must be name of a table you want to get all data from. All rows and columns are retrieved.

dotConnect for MySQL supports named and unnamed parameters. Parameters of stored procedures can be used only as input, output values will be ignored. You can read about using named and unnamed parameters at "Using parameters" article.

Example

The following example creates an instance of a derived class MySqlCommand and sets some of its properties.

csharp

public void CreateCommand()
{
  MySqlCommand myCommand = new MySqlCommand();
  myCommand.CommandText = "SELECT * FROM Test.Dept ORDER BY DeptNo";
  myCommand.CommandType = CommandType.Text;
}

Visual Basic

Public Sub CreateCommand()
  Dim myCommand As New MySqlCommand()
  myCommand.CommandText = "SELECT * FROM Test.Dept ORDER BY DeptNo"
  myCommand.CommandType = CommandType.Text
End Sub

Reference

MySqlCommand Class
MySqlCommand Members
CommandText Property

Send Feedback