CommandType Property

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

[Visual Basic]
Overrides Public Property CommandType As CommandType

[C#]
public override CommandType CommandType {get; set;}

Return Type

One of the CommandType values. The default value is 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.

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.

Example

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

[C#]

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

[Visual Basic]

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

See Also

Language

CommandType Property

Return Type

Remarks

Example

See Also