| aspxtreme |
Home Getting Started Web Forms Web Applications ADO.NET ASP/ADO Back to Basics |
  |
SqlDataSource.SelectParameters Property
System.Web.UI.WebControls Namespace SqlDataSource Class
.NET Framework version 2.0
Returns the parameters collection that contains the parameters that are used by the SelectCommand property from the SqlDataSourceView object that is associated with the SqlDataSource control.
Syntax
| Inline | <asp:SqlDataSource selectparameters = objCollection ... > |
|---|---|
| Script | SqlDataSource.SelectParameters [ = objCollection ] |
Property Value
| objCollection | A ParameterCollection that contains the parameters used by the SelectCommand property. |
The property is read/write with no default value.
Remarks
If the SelectCommand property contains a parameterized SQL query, the SelectParameters collection contains any Parameter objects that correspond to the parameter placeholders in the SQL string.
Depending on the ADO.NET provider, the order of the parameters in the SelectParameters collection might be important. The System.Data.OleDb and System.Data.Odbc providers associate the parameters in the collection according to the order that the parameters appear in the parameterized SQL query. The System.Data.SqlClient provider, which is the default ADO.NET provider for the SqlDataSource control, associates the parameters in the collection by matching the name of the parameter with a placeholder alias in the SQL query. For more information on parameterized SQL queries and commands, see Using Parameters with the SqlDataSource Control.
The SelectParameters property retrieves the SelectParameters property that is contained by the SqlDataSourceView object that is associated with the SqlDataSource control.
