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

SqlDataSource.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 */
public ConflictOptions get_ConflictDetection ()

/** @property */
public void set_ConflictDetection (ConflictOptions value)

public function get ConflictDetection () : ConflictOptions

public function set ConflictDetection (value : ConflictOptions)

Not applicable.

Property Value

One of the ConflictOptions values. The default is the ConflictOptions.OverwriteChanges value.

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 DataTable 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 method. 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 property.) The SqlDataSource control then determines if the Update method that is specified in the UpdateCommand property has parameters that match.

Concurrency control is a technique that 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, your Update method can then compare the old and new values to the original data source to detect conflicts and handle them, as necessary.

The ConflictDetection property delegates to the ConflictDetection property of the SqlDataSourceView object that is associated with the SqlDataSource control.

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

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0

Community Additions

ADD
Show:
© 2015 Microsoft