Advanced SQL Generation Options Dialog Box - SqlDataSource

The Advanced SQL Generation Options dialog box enables you to generate INSERT, UPDATE, and DELETE statements to update the data source.

Tasks

Generate INSERT, UPDATE, and DELETE statements
This check box, when selected, creates SQL statements for the SqlDataSource control's InsertCommand, UpdateCommand, and DeleteCommand objects.

If this check box is cleared, the remaining option in the dialog box is disabled as it does not apply.

For more information about modifying data using the SqlDataSource control, see Modifying Data using the SqlDataSource Control
Use optimistic concurrency
This element sets how the SqlDataSource control handles conflicts when updating or deleting data. When Use optimistic concurrency is selected, the ConflictDetection property is set to the value CompareAllValues. When Use optimistic concurrency is not selected, the ConflictDetection property is set to the value OverwriteChanges, which is the default value.

Note

This option is available only if the Generate INSERT, UPDATE, and DELETE statements check box is selected.

For more information about concurrency checking when updating from a dataset, see Introduction to Data Concurrency in ADO.NET.