Chapter 6: Creating and Inserting Records

Chapter 6 - Creating and Inserting Records
byJohn Kauffman, Fabio Claudio Ferracchiatiet al.?
Wrox Press ?2002

Overview

In previous chapters, we've seen how to use data readers and datasets to retrieve data from a data source. In this chapter, we'll analyze how to insert new records into a database table, using SQL code that's created by and called from ADO.NET objects. In particular, we will focus on the following topics:

• The basics of inserting records

• How to use ASP.NET validation controls to prevent errors during insert operations

• How to use command and dataset objects to perform record insertions

• How to use TextBox and Calendar controls for record creation

• How command builder objects can write SQL code on our behalf