Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

CommandType property

Specifies the type of command to be executed.

Visual Basic

Public Overrides Property CommandType As CommandType

C#

public override CommandType CommandType { get; set; }

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

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.

• 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