Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

CommandType Enumeration

Specifies how a command string is interpreted.

Namespace:  Microsoft.ReportingServices.DataProcessing
Assemblies:   Microsoft.ReportingServices.Interfaces (in Microsoft.ReportingServices.Interfaces.dll)
  Microsoft.ReportingServices.SharePoint.UI.WebParts (in Microsoft.ReportingServices.SharePoint.UI.WebParts.dll)
public enum CommandType
Member nameDescription
StoredProcedureThe name of a stored procedure.
TableDirectWhen 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.
TextA text command.

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 ExecuteReader.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.