SqlDataSourceView.SelectCommandType Property

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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)

public SqlDataSourceCommandType SelectCommandType { get; set; }

Property Value

Type: System.Web.UI.WebControls.SqlDataSourceCommandType

One 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
Return to top
Show: