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)
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.
<!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>
.NET Framework
Available since 2.0
Available since 2.0
Show: