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


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

Get Sams Teach Yourself ASP.NET 3.5 in 24 Hours, Complete Starter Kit now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.