An Overview of Inserting, Updating, and Deleting examined using the Object Data Source to facilitate inserting, updating, and deleting with the Grid View, Details View, and Form View controls.Alternatively, the Sql Data Source can be used in place of the Object Data Source.As discussed in An Overview of Inserting, Updating, and Deleting, the Grid View control provides built-in updating and deleting capabilities, while the Details View and Form View controls include inserting support along with editing and deleting functionality.These data modification capabilities can be plugged directly into a data source control without a line of code needing to be written.For now, leave this checkbox unchecked; we'll examine optimistic concurrency with the Sql Data Source control in the next tutorial.After checking the Generate statements checkbox, click OK to return to the Configure Select Statement screen, then click Next, and then Finish, to complete the Configure Data Source wizard.
However, this approach requires that we manually write out the SQL statements by hand, which can be monotonous and error-prone.
Since the Note 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.
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.
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.