Sams Teach Yourself ASP.NET 4 in 24 Hours: Complete Starter Kit

Hour 16. Deleting, Inserting, and Editing Data

In this hour, we will cover

• Configuring the SqlDataSource for updating, inserting, and deleting

• Learning the basics of the UPDATE, INSERT, and DELETE statements

• Editing and deleting data with the GridView

• Inserting data with the DetailsView

ASP.NET’s data Web controls make displaying data a breeze—simply drag a GridView or DetailsView onto a page and bind it to a configured data source control. In addition to displaying database data, we may need to let a user modify the database’s contents. For example, in the preceding hour we saw how to show the list of books in the Books table. It might be nice to allow visitors to add their own books to this table or to leave comments about a particular ...