Specifies the type of command to be executed.

Syntax

Visual Basic

Public Overrides Property CommandType As CommandType

C#

public override CommandType CommandType  { get; set; }

Property value

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

Remarks

Supported command types are as follows:

• System.Data.CommandType.TableDirect - UL Ext.: When you specify this CommandType, the ULCommand.CommandText must be the name of a database table. You can also specify the index used to open (sort) the table with ULCommand.IndexName. Use ULCommand.ExecuteTable() or ULCommand.ExecuteReader() to access the table.
• System.Data.CommandType.Text - When you specify this CommandType, the ULCommand.CommandText must be a SQL statement or query. Use ULCommand.ExecuteNonQuery to execute a non-query SQL statement and use either ULCommand.ExecuteReader() or ULCommand.ExecuteScalar to execute a query.

See also

• ULCommand class
• ULCommand members
•  CommandType
•  CommandType.Text
•  CommandType.TableDirect
• CommandText property
• IndexName property
• ExecuteTable() method
• ExecuteReader() method
•  CommandType.Text
• CommandText property
• ExecuteNonQuery method
• ExecuteReader() method
• ExecuteScalar method