This documentation is archived and is not being maintained.

SqlDataSourceCommandType Enumeration

Describes the type of SQL command used by the SqlDataSource and AccessDataSource controls when performing a database operation.

Namespace:  System.Web.UI.WebControls
Assembly:  System.Web (in System.Web.dll)

public enum class SqlDataSourceCommandType

Member nameDescription
TextThe text contained in a corresponding text property is a SQL query or command.
StoredProcedureThe text contained in a corresponding text property is the name of a stored procedure.

The SqlDataSourceCommandType enumeration is used by the SqlDataSource and AccessDataSource controls to describe the type of SQL command contained in the SelectCommand, InsertCommand, UpdateCommand, and DeleteCommand properties. The Text value indicates that the text is a SQL query or command string while the StoredProcedure value indicates that the text is the name of a stored procedure.

The following code example demonstrates how to set the SelectCommand text to the name of a stored procedure and the SelectCommandType property to the StoredProcedure value to retrieve data from a Microsoft SQL Server database and display it in a DropDownList.

No code example is currently available or this language may not be supported.

.NET Framework

Supported in: 4, 3.5, 3.0, 2.0

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

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