Sams Teach Yourself ASP.NET 2.0 in 24 Hours

Chapter 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, which are SQL statements for modifying database data

• Editing and deleting data with the GridView

• Inserting data with the DetailsView

As we saw in Hour 15, “Displaying Data with the Data Web Controls,” the ASP.NET data Web controls make displaying data a breeze. We simply drag a GridView or DetailsView onto an ASP.NET page and bind it to a configured data source control. Although displaying database information on a web page is handy, sometimes we might want to let a user modify the database’s contents. For example, in the preceding hour we ...