Export (0) Print
Expand All

SqlDataSourceView.ConflictDetection Property

Gets or sets the value indicating how the SqlDataSource control performs updates and deletes when data in a row in the underlying database changes during the time of the operation.

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

public ConflictOptions ConflictDetection { get; set; }

Property Value

Type: System.Web.UI.ConflictOptions
One of the ConflictOptions values. The default is the ConflictOptions.OverwriteChanges value.

ExceptionCondition
ArgumentOutOfRangeException

The selected value is not one of the ConflictOptions values.

The ConflictDetection property determines whether parameters for old and new values are applied to the Update method. For example, if the command that is specified by the SelectCommand property returns a DataSet object with the columns Name and Number, and the ConflictDetection property is set to the OverwriteChanges value, parameters are created for Name and Number for the update operation. If the ConflictDetection property is set to the CompareAllValues value, parameters are created for Name, Number, original_Name, and original_Number. (The exact name of the parameters for the original values depends on the OldValuesParameterFormatString.) Then, the SqlDataSourceView object determines if the method that is specified in the UpdateCommand property has parameters that match.

Concurrency control is a technique data stores use to control how data is read and changed in the store when multiple clients are accessing and manipulating the same data. For example, one client reads data and presents it to a user, while another client reads the same data, and presents it to a different user. If both users update the data and submit it to the data storage, some unexpected result might occur, because both clients might update different values for the same data. This is considered a conflict. By setting the ConflictDetection property to the CompareAllValues value, the update operation can then compare the old and new values to the original data source to detect conflicts and handle them as required.

The value of the ConflictDetection property is stored in view state.

.NET Framework

Supported in: 4.5.2, 4.5.1, 4.5, 4, 3.5, 3.0, 2.0

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

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

Show:
© 2014 Microsoft