Chapter 7: Updating and Deleting Records

Chapter 7 - Updating and Deleting Records
byJohn Kauffman, Fabio Claudio Ferracchiatiet al.?
Wrox Press ?2002

Overview

If you listen to conversations among database programmers, a word you might hear more frequently than you'd otherwise expect is "CRUD". That word is an acronym for Create, Read, Update, and Delete - the four basic database operations that are performed thousands of times every second, by machines all over the world. Every book about database programming covers these four operations, and this one is no exception.

In previous chapter, we described how you could create and then add new records to a table. That means we've got the first half of CRUD covered already; the second half - updating and deleting the records in a database - is the subject of this chapter. Specifically, you will see how to:

  • Update and delete records in a database using SQL's UPDATE and DELETE statements

  • Update and delete records in a database using ADO.NET command objects

  • Create a web front end for database access using ASP.NET DataGrid control

  • Capture user input and perform database operations using ASP.NET's event handling features

  • Modify in-memory data and update a database using ADO.NET dataset and data adapter objects

  • Validate data input and user actions



Beginning ASP. NET 2.0 and Databases
Beginning ASP.NET 2.0 and Databases (Wrox Beginning Guides)
ISBN: 0471781347
EAN: 2147483647
Year: 2004
Pages: 263

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net