CommandType Enumeration
Specifies how a command string is interpreted.
[Visual Basic] <Serializable> Public Enum CommandType [C#] [Serializable] public enum CommandType [C++] [Serializable] __value public enum CommandType [JScript] public Serializable enum CommandType
Remarks
When the CommandType property is set to StoredProcedure, set the CommandText property to the name of the stored procedure. The command executes this stored procedure when you call one of the Execute methods of a Command object.
Members
| Member name | Description |
|---|---|
| StoredProcedure Supported by the .NET Compact Framework. | The name of a stored procedure. |
| TableDirect Supported by the .NET Compact Framework. | When the CommandType property is set to TableDirect, the CommandText property should be set to the name of the table or tables to be accessed. The user may be required to use escape character syntax or include qualifying characters if any of the tables named contain any special characters. All rows and columns of the named table or tables will be returned when you call one of the Execute methods.
In order to access multiple tables, use a comma delimited list, without spaces or padding, containing the names of the tables to access. When the CommandText property names multiple tables, a join of the specified tables is returned. Note TableDirect is only supported by the .NET Framework Data Provider for OLE DB. |
| Text Supported by the .NET Compact Framework. | An SQL text command. (Default.) |
Requirements
Namespace: System.Data
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, .NET Compact Framework
Assembly: System.Data (in System.Data.dll)