NET web pages commonly display messages in response to user actions.For instance, a typical CRUD (Create, Read, Update, Delete) web page might display the message, "Record deleted" immediately after deleting a record and the message "Record updated" immediately after updating a record.Click on the "Advanced" button and check the "Generate INSERT, UPDATE and DELETE statements" checkbox (Figure 3). Now that you have configured the SQL Data Source control let's bind it with a Grid View control. Open its smart tag and configure it as shown in Figure 4.Here, we set the Data Source of the Grid View to Sql Data Source1. We also enable paging, sorting and editing features of the Grid View.Know the inner dimension of personal growth and well-being. NET 2.0 Grid View control allows us to quickly edit and delete records.A yogic approach to success, happiness, and inner transformation. However, most of the real world cases call for validating the data being edited or deleted. Drag and drop an SQL Data Source control on the web form.Inserting, updating, or deleting data from the Grid View, Details View, or Form View precipitates the same sequence of pre- and post-level events for both the data Web control and the Object Data Source. Figure 3: Choose (None) From the Drop-Down List for the INSERT and DELETE Tabs (Click to view full-size image) After completing this wizard check the Enable Editing checkbox from the Grid View's smart tag. The event handlers for these three events are passed an object of type Object Data Source Method Event Args that has two properties of interest: To illustrate working with the parameter values at the Object Data Source level, let's include a Details View in our page that allows the users to add a new product.Figure 1: A Series of Pre- and Post-Events Fire When Updating Data in a Grid View (Click to view full-size image) In this tutorial we'll examine using these events to extend the built-in inserting, updating, and deleting capabilities of the ASP. We'll also see how to customize the editing interface to only update a subset of the product fields. With the completion of the Create Data Source wizard and binding that to the Grid View, Visual Studio has created the declarative syntax for both controls. This Details View will be used to provide an interface for quickly adding a new product to the database.
On the next step select Customer ID, Company Name, Contact Name and Country columns (Figure 2).
This control may be located at the top of the page and have its property value is remembered across postbacks.
Consequently, if a user deletes a record the "Record deleted" message is displayed.
In this tutorial we'll examine using the events that occur before, during, and after an insert, update, or delete operation of an ASP. We'll also see how to customize the editing interface to only update a subset of the product fields.
When using the built-in inserting, editing, or deleting features of the Grid View, Details View, or Form View controls, a variety of steps transpire when the end user completes the process of adding a new record or updating or deleting an existing record.
Likewise, there would be messages displayed for inserting a new record and messages displayed in the event of an error.