Export (0) Print
Expand All
Expand Minimize
3 out of 4 rated this helpful - Rate this topic

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)

See Also

System.Data Namespace

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.