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.
Since the The Details View s inserting and editing interfaces lack any sort of customization or validation.
To add validation controls or to customize the interfaces, you need to convert the Bound Fields to Template Fields.
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.
Clicking the Edit button turns the Details View into edit mode, which displays each Bound Field whose (the default) as a Text Box, and the Check Box Field as a checkbox.
Figure 9: The Details View s Default Editing Interface (Click to view full-size image) Similarly, you can delete the currently selected product or add a new product to the system.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.Figure 2: Select the Delete Query Property from the Properties Window provide a value for this parameter (leave its Parameter source at None ).Once we add deleting support to the Grid View, the Grid View will automatically supply this parameter value, using the value of its property added, the Grid View s smart tag now contains the Enable Deleting option. As discussed in An Overview of Inserting, Updating, and Deleting, this causes the Grid View to add a Command Field with its .To accomplish this we need to specify values for the Sql Data Source control s statement created in Step 2.