SqlDataSourceView.ExecuteDelete(IDictionary, IDictionary) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Performs a delete operation using the DeleteCommand SQL string, any parameters that are specified in the DeleteParameters collection, and the values that are in the specified keys and oldValues collections.
protected:
override int ExecuteDelete(System::Collections::IDictionary ^ keys, System::Collections::IDictionary ^ oldValues);protected override int ExecuteDelete (System.Collections.IDictionary keys, System.Collections.IDictionary oldValues);override this.ExecuteDelete : System.Collections.IDictionary * System.Collections.IDictionary -> intProtected Overrides Function ExecuteDelete (keys As IDictionary, oldValues As IDictionary) As IntegerParameters
- keys
- IDictionary
An IDictionary of object or row key values for the ExecuteDelete(IDictionary, IDictionary) operation to delete.
- oldValues
- IDictionary
An IDictionary that contains row values that are evaluated only if the ConflictDetection property is set to the CompareAllValues value.
Returns
A value that represents the number of rows deleted from the underlying database.
Exceptions
The SqlDataSource cannot establish a connection with the underlying data source.
-or-
The ConflictDetection property is set to the CompareAllValues value and no oldValues parameters are passed.
The current user does not have the correct permissions to access to the database.
-or-
The instance of the control is an AccessDataSource control and access is denied to the path specified for the DataFile property.
The CanDelete property is false.
-or-
A design-time relative path was not mapped correctly by the designer before using an instance of the AccessDataSource control.
Remarks
The SqlDataSourceView class implements the inherited ExecuteDelete method to delete data from a database. Page developers and data-bound control authors do not call the ExecuteDelete method directly; instead, use the publicly exposed Delete method.
The values that are contained in the keys collection are evaluated and merged with any values that are contained by the DeleteParameters collection. If the ConflictDetection property is set to the CompareAllValues value, the values that are contained in the oldValues collection are formatted with the OldValuesParameterFormatString property and are also merged.
Before the delete operation is performed, the OnDeleting method is called to raise the Deleting event. You can handle this event to examine the values of the parameters and to perform any preprocessing before a delete.
To perform a delete operation, the SqlDataSourceView object builds a DbCommand object using the DeleteCommand text and any associated DeleteParameters properties, and then executes the DbCommand object against the underlying database. After the delete operation completes, the OnDeleted method is called to raise the Deleted event. You can handle this event to examine any return values and error codes and to perform any post-processing.
