In this chapter, we have looked at the basic theory of inserting records into a database using standard SQL statements. You've learned how to write code in order to execute INSERT commands using ADO.NET command objects. You've also seen how, by using the Parameters collection that's exposed by command objects, you can write more readable code. Finally, we have examined how to use DataSet objects in conjunction with data adapter objects in order to insert values read from ASP.NET forms and XML files. So: you know how to create new records, and how to insert them into a database - but that's only half the story. In the next chapter, we will look at how to modify and delete existing database records. |