SqlDataSourceView::SelectCommandType Property
.NET Framework (current version)
Gets or sets a value indicating whether the text in the SelectCommand property is a SQL query or the name of a stored procedure.
Assembly: System.Web (in System.Web.dll)
public: property SqlDataSourceCommandType SelectCommandType { SqlDataSourceCommandType get(); void set(SqlDataSourceCommandType value); }
Property Value
Type: System.Web.UI.WebControls::SqlDataSourceCommandTypeOne of the SqlDataSourceCommandType values. The default is the Text value.
| Exception | Condition |
|---|---|
| ArgumentOutOfRangeException | The selected value is not one of the SqlDataSourceCommandType values. |
The value of the SelectCommandType property is stored in view state.
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.
.NET Framework
Available since 2.0
Available since 2.0
Show: