SqlDataSourceView.SelectCommandType Property
Gets or sets a value indicating whether the text in the SelectCommand property is a SQL query or the name of a stored procedure.
Namespace: System.Web.UI.WebControls
Assembly: System.Web (in System.Web.dll)
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 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.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>ASP.NET Example</title> </head> <body> <form id="form1" runat="server"> <asp:DropDownList id="DropDownList1" runat="server" DataTextField="LastName" DataSourceID="SqlDataSource1" /> <asp:SqlDataSource id="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyNorthwind%>" SelectCommandType="StoredProcedure" SelectCommand="sp_lastnames"> </asp:SqlDataSource> <!-- The sp_lastnames stored procedure is CREATE PROCEDURE sp_lastnames AS SELECT LastName FROM Employees GO --> </form> </body> </html>
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.
