SqlDataSourceView.SelectCommandType Property
.NET Framework 3.0
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)
Assembly: System.Web (in system.web.dll)
public: property SqlDataSourceCommandType SelectCommandType { SqlDataSourceCommandType get (); void set (SqlDataSourceCommandType value); }
/** @property */ public SqlDataSourceCommandType get_SelectCommandType () /** @property */ public void set_SelectCommandType (SqlDataSourceCommandType value)
public function get SelectCommandType () : SqlDataSourceCommandType public function set SelectCommandType (value : SqlDataSourceCommandType)
Not applicable.
Property Value
One of the SqlDataSourceCommandType values. The default is the Text value.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="Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind;"
SelectCommand="sp_lastnames">
</asp:SqlDataSource>
<!--
The sp_lastnames stored procedure is
CREATE PROCEDURE sp_lastnames AS
SELECT LastName FROM Employees
GO
-->
</form>
</body>
</html>
Community Additions
ADD
Show: