SelectCommandType Property

SqlDataSource.SelectCommandType Property


Gets or sets a value indicating whether the text in the SelectCommand property is an SQL query or the name of a stored procedure.

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

public SqlDataSourceCommandType SelectCommandType { get; set; }

Property Value

Type: System.Web.UI.WebControls.SqlDataSourceCommandType

One of the SqlDataSourceCommandType values. The default is the Text value.

The SelectCommandType property delegates to the SelectCommandType property of the SqlDataSourceView object that is associated with the SqlDataSource control.

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, in order to retrieve data from a Microsoft SQL Server database and display it in a DropDownList control.

.NET Framework
Available since 2.0
Return to top
© 2015 Microsoft