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 DeleteCommand property from the SqlDataSourceView object that is associated with the SqlDataSource control.
Inline |
<asp:SqlDataSource deleteparameters = objCollection ... > |
Script |
SqlDataSource.DeleteParameters [ = objCollection ] |
objCollection |
A ParameterCollection that contains the parameters used by the DeleteCommand property. |
The property is read/write with no default value.
If the DeleteCommand property contains a parameterized SQL query, the DeleteParameters collection contains any Parameter objects that correspond to the parameter placeholders in the SQL string.
If the ConflictDetection property is set to the CompareAllValues value, the parameters are created for both the old and new values of the data. The parameters for the old values are named according to the OldValuesParameterFormatString property.
Depending on the ADO.NET provider, the order of the parameters in the DeleteParameters collection might be important. The System.Data.OleDb and System.Data.Odbc providers associate the parameters in the collection according to the order in which 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 the placeholder in the SQL query. For more information on parameterized SQL queries and commands, see Using Parameters with the SqlDataSource Control.
The DeleteParameters property retrieves the DeleteParameters property that is contained by the SqlDataSourceView objedt that is associated with the SqlDataSource control.