Fortunately, the Configure Data Source wizard provides an option to have the statements checkbox will only be checkable if the table selected has a primary key and the primary key column (or columns) are included in the list of returned columns.
The Use optimistic concurrency checkbox, which becomes selectable once the Generate statements to provide optimistic concurrency control.
To accomplish this we need to specify values for the Sql Data Source control s statement created in Step 2.
For now, let s use the Properties window in the Designer, although the Configure Data Source wizard or declarative syntax option would work just as well.
Visit the page in a browser and note the Edit, Delete, and New buttons included in the Details View.
These values can be: hard-coded directly in the In order for the data Web controls to utilize their built-in inserting, editing, and deleting capabilities, the data source control they are bound to must offer such functionality.
For the Sql Data Source, this means that properties.
From the Designer in Sql Data Source and then bring up the Properties window (from the View menu, choose Properties window, or simply hit F4).
Select the Delete Query property, which will bring up a set of ellipses.