United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

.NET Development

.NET Framework 4.5

.NET Framework Class Library

System.Data Namespaces

System.Data

AcceptRejectRule Enumeration

CommandBehavior Enumeration

CommandType Enumeration

ConflictOption Enumeration

ConnectionState Enumeration

Constraint Class

ConstraintCollection Class

ConstraintException Class

DataColumn Class

DataColumnChangeEventArgs Class

DataColumnChangeEventHandler Delegate

DataColumnCollection Class

DataException Class

DataRelation Class

DataRelationCollection Class

DataRow Class

DataRowAction Enumeration

DataRowBuilder Class

DataRowChangeEventArgs Class

DataRowChangeEventHandler Delegate

DataRowCollection Class

DataRowComparer Class

DataRowComparer(TRow) Class

DataRowExtensions Class

DataRowState Enumeration

DataRowVersion Enumeration

DataRowView Class

DataSet Class

DataSetDateTime Enumeration

DataSetSchemaImporterExtension Class

DataSysDescriptionAttribute Class

DataTable Class

DataTableClearEventArgs Class

DataTableClearEventHandler Delegate

DataTableCollection Class

DataTableExtensions Class

DataTableNewRowEventArgs Class

DataTableNewRowEventHandler Delegate

DataTableReader Class

DataViewManager Class

DataViewRowState Enumeration

DataViewSetting Class

DataViewSettingCollection Class

DBConcurrencyException Class

DbType Enumeration

DeletedRowInaccessibleException Class

DuplicateNameException Class

EntityCommandCompilationException Class

EntityCommandExecutionException Class

EntityException Class

EntityKey Class

EntityKeyMember Class

EntitySqlException Class

EntityState Enumeration

EnumerableRowCollection Class

EnumerableRowCollection(TRow) Class

EnumerableRowCollectionExtensions Class

EvaluateException Class

FillErrorEventArgs Class

FillErrorEventHandler Delegate

ForeignKeyConstraint Class

IColumnMapping Interface

IColumnMappingCollection Interface

IDataAdapter Interface

IDataParameter Interface

IDataParameterCollection Interface

IDataReader Interface

IDataRecord Interface

IDbCommand Interface

IDbConnection Interface

IDbDataAdapter Interface

IDbDataParameter Interface

IDbTransaction Interface

IExtendedDataRecord Interface

InRowChangingEventException Class

InternalDataCollectionBase Class

InvalidCommandTreeException Class

InvalidConstraintException Class

InvalidExpressionException Class

IsolationLevel Enumeration

ITableMapping Interface

ITableMappingCollection Interface

KeyRestrictionBehavior Enumeration

LoadOption Enumeration

MappingException Class

MappingType Enumeration

MergeFailedEventArgs Class

MergeFailedEventHandler Delegate

MetadataException Class

MissingMappingAction Enumeration

MissingPrimaryKeyException Class

MissingSchemaAction Enumeration

NoNullAllowedException Class

ObjectNotFoundException Class

OperationAbortedException Class

OptimisticConcurrencyException Class

OrderedEnumerableRowCollection(TRow) Class

ParameterDirection Enumeration

PropertyAttributes Enumeration

PropertyCollection Class

PropertyConstraintException Class

ProviderIncompatibleException Class

ReadOnlyException Class

RowNotInTableException Class

Rule Enumeration

SchemaSerializationMode Enumeration

SchemaType Enumeration

SerializationFormat Enumeration

SqlDbType Enumeration

StateChangeEventArgs Class

StateChangeEventHandler Delegate

StatementCompletedEventArgs Class

StatementCompletedEventHandler Delegate

StatementType Enumeration

StrongTypingException Class

SyntaxErrorException Class

TypedDataSetGenerator Class

TypedDataSetGeneratorException Class

TypedTableBase(T) Class

TypedTableBaseExtensions Class

UniqueConstraint Class

UpdateException Class

UpdateRowSource Enumeration

UpdateStatus Enumeration

VersionNotFoundException Class

XmlReadMode Enumeration

XmlWriteMode Enumeration

Minimize

2 out of 5 rated this helpful - Rate this topic

CommandType Enumeration

.NET Framework 4.5

Specifies how a command string is interpreted.

Namespace: System.Data
Assembly: System.Data (in System.Data.dll)

public enum CommandType

	Member name	Description
	StoredProcedure	The name of a stored procedure.
	TableDirect	The name of a table.
	Text	An SQL text command. (Default.)

When the CommandType property is set to StoredProcedure, the CommandText property should be set to the name of the stored procedure to be accessed. The user may be required to use escape character syntax or include qualifying characters if any of the specified 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 of a Command object.

When the CommandType property is set to TableDirect, the CommandText property should be set to the name of the table 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 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. Multiple table access is not supported when CommandType is set to TableDirect.

Version Information

.NET Framework

Supported in: 4.5, 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Reference

System.Data Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.

|

Site Feedback

© 2013 Microsoft. All rights reserved.