Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

SqlDataSourceView.ExecuteUpdate Method

Note: This method is new in the .NET Framework version 2.0.

Performs an update operation using the UpdateCommand SQL string, any parameters that are in the UpdateParameters collection, and the values that are in the specified keys, values, and oldValues collections.

Namespace: System.Web.UI.WebControls
Assembly: System.Web (in system.web.dll)

protected override int ExecuteUpdate (
	IDictionary keys,
	IDictionary values,
	IDictionary oldValues
)
protected int ExecuteUpdate (
	IDictionary keys, 
	IDictionary values, 
	IDictionary oldValues
)
protected override function ExecuteUpdate (
	keys : IDictionary, 
	values : IDictionary, 
	oldValues : IDictionary
) : int

Parameters

keys

An IDictionary of primary keys to use with the UpdateCommand property to perform the update database operation. If there are no keys associated with the query or if the UpdateCommand property is not a parameterized SQL query, pass a null reference (Nothing in Visual Basic).

values

An IDictionary of values to use with the UpdateCommand property to perform the update database operation. If there are no parameters associated with the query or if the UpdateCommand is not a parameterized SQL query, pass a null reference (Nothing in Visual Basic).

oldValues

An IDictionary that represents the original values in the database. If there are no parameters associated with the query or if the UpdateCommand property is not a parameterized SQL query, pass a null reference (Nothing in Visual Basic).

Return Value

A value that represents the number of rows updated in the underlying database.

Exception typeCondition

InvalidOperationException

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.

HttpException

The current user does not have the correct permissions to gain access to the database.

NotSupportedException

The CanUpdate property is false.

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

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

Before the update operation is performed, the OnUpdating method is called to raise the 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 SqlDataSourceView builds a DbCommand object using the UpdateCommand text and any associated UpdateParameters properties, and then executes the DbCommand object against the underlying database. After the operation completes, the OnUpdated method is called to raise the Updated event. You can handle this event to examine any return values and error codes and to perform any post-processing.

Windows 98, Windows 2000 SP4, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0

Community Additions

ADD
Show:
© 2015 Microsoft