Sams Teach Yourself ASP.NET 3.5 in 24 Hours, Complete Starter Kit

Chapter 16. Deleting, Inserting, and Editing Data

<feature><title></title>

In this hour, we will cover

• Configuring the SqlDataSource for updating, inserting, and deleting

• Learning the basics of the UPDATE, INSERT, and DELETE statements, which are SQL statements for modifying database data

• Editing and deleting data with the GridView

• Inserting data with the DetailsView

</feature>

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 ...