Summary

Yes, there are a few pieces left out of this chapter that I included in my earlier book ADO and ADO.NET Examples and Best Practices for Visual Basic Programmers, but I've given you all of the essential ingredients to help you set up and manage changes for your database. I didn't want to repeat that information here. I have discussed how to use the TableAdapter (and DataAdapter) wizards to create updateable DataTable and DataSet objects, as well as how to customize these to meet the needs of your application architecture. In all of my examples, I tried to avoid use of the CommandBuilder (as most other books take that route) and emphasize designs that are more like the ones your DBA will insist uponthose that leverage stored procedures and scalable architectures. All of the stored procedures used here and elsewhere in the book are in the Biblio or one of the other half-dozen or so sample databases that are included on the book's DVD. I encourage you to explore these procedures. You'll also discover that the Biblio database (and especially the Customers table) has a trigger that demonstrates how to implement a simple business rule in T-SQL server-side code.

I expect to revisit this subject in one or more EBooks as well.