This impact on the database could be lessened by caching the returned categories either in a per-request cache or through the Caching Layer using a SQL caching dependency or a very short time-based expiry.For more information on the per-request caching option, see We ve made a number of changes to the Grid View s templates without pausing to view our progress.

updating access database-83updating access database-38updating access database-20

In this tutorial we'll build a Grid View where each row is editable (see Figure 1).

Since each row is rendered in its editing interface, there s no need for a column of Edit, Update, and Cancel buttons.

Remove all but the properties of the first three fields to Product, Category, and Price, respectively.

Lastly, check the Enable Paging and Enable Sorting checkboxes in the Grid View s smart tag.

While the steps here are complete, they are presented tersely.

For a more in-depth look at creating and configuring the categories Drop Down List, refer back to the Customizing the Data Modification Interface tutorial.

After completing this tutorial I encourage you to return to the earlier tutorial and update it to use the database transaction-related functionality added in the preceding tutorial.

As discussed in the An Overview of Inserting, Updating, and Deleting Data tutorial, the Grid View offers built-in support for editing its underlying data on a per-row basis.

Next, select each field and click the Convert this field into a Template Field link.

Figure 5: Convert the Existing Bound Fields and Check Box Field Into Template Field Now that each field is a Template Field, we re ready to move the editing interface from the The Customizing the Data Modification Interface tutorial contains a more thorough and complete discussion on customizing a template to include a Drop Down List as opposed to a Text Box.

In order to update a set of records, we'll need to write a bit of code in the ASP.