The System.Web.UI.WebControls.SqlDataSourceView class implements the inherited SqlDataSourceView.ExecuteUpdate(IDictionary, IDictionary, IDictionary) method to update data in a database. Page developers and data-bound control authors do not call the SqlDataSourceView.ExecuteUpdate(IDictionary, IDictionary, IDictionary) method directly; instead, use the publicly exposed SqlDataSource.Update method.

The values contained in the keys and values collections are evaluated and merged with any values contained by the SqlDataSourceView.UpdateParameters collection. If the SqlDataSourceView.ConflictDetection property is set to System.Web.UI.ConflictOptions.CompareAllValues, the values contained in the oldValues collection are formatted with the SqlDataSourceView.OldValuesParameterFormatString and also merged.

Before the update operation is performed, the SqlDataSourceView.OnUpdating(SqlDataSourceCommandEventArgs) method is called to raise the SqlDataSourceView.Updating event. You can handle this event to examine the values of the parameters and perform any preprocessing before an update.

To perform the operation, the System.Web.UI.WebControls.SqlDataSourceView builds a System.Data.Common.DbCommand object using the SqlDataSourceView.UpdateCommand text and any associated SqlDataSourceView.UpdateParameters properties, and then executes the System.Data.Common.DbCommand object against the underlying database. After the operation completes, the SqlDataSourceView.OnUpdated(SqlDataSourceStatusEventArgs) method is called to raise the SqlDataSourceView.Updated event. You can handle this event to examine any return values and error codes and to perform any post-processing.

Namespace: System.Web.UI.WebControls
Assembly: System.Web (in System.Web.dll)
Assembly Versions: 2.0.0.0
Since: .NET 2.0