Visual Basic 2008 Programming: Business Applications with a Design Perspective
Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapter 9
Chapter 10 Chapter 11 Chapter 12 Chapter 13 Chapter 14 Appendix A Appendix B Appendix C Home
Loading
Last change: February 13 2016 18:48:19.

 Chapter in PDF

Table of Contents

Chapter 9: Database and ADO.NET
Last change: February 13 2016 18:47:33.

Explore and Discover

9-1. Validating Bound Controls 9-2. Bound Controls for Tables with Parent-Child Relationship

Exercises

9-3. Maintaining the CallLog Table 9-4. Maintaining the CallLog Table with Parameters 9-5. Maintaining the CallLog Table by the Table Adapter 9-6. Viewing Call Logs by Phone Number
9-7. Viewing Call Logs by Phone Number (Dataset and Relation) 9-8. Maintaining the Product Table by Commands with Parameters 9-9. Maintaining the Product Table by the Data Adapter Only 9-10. Viewing a Selected Product Record: Use of Data Reader
9-11. Viewing a Selected Product Record: Use of Data Reader and Data Table/a> 9-12. Maintaining the Customer Table by Data Commands with Parameters 9-13. Maintaining the Customer Table by the Table Adapter 9-14. Viewing a Selected Customer Record: Use of Data Reader
9-15. Viewing a Selected Customer Record: Use of Data Reader and Data Table 9-16. Maintaining the Customer Transaction Table by Commands with Parameters 9-17. Maintaining the Customer Transaction Table by the table Adapter 9-18. Maintaining the Customer Table by the Data Adapter Only
9-19. Viewing All Transactions for a Selected Customer: Use of the Data Reader 9-20. Obtaining Total Transaction Amounts for All Active Accounts Through Stored Procedure: Use of Data Reader and Data Table 9-21. Computing Customer Balances 9-22. Maintaining the Chart of Accounts Table by Commands with Parameters
9-23. Maintaining the Account Table by the Data Adapter Only 9-24. Maintaining the Chart of Accounts Table by the Table Adapter 9-25. Viewing a Selected Account Record: Use of Data Reader 9-26. Maintaining the Journal Entry Tables by Commands with Parameters
9-27. Maintaining the Journal Entry Tables (both Journal and Entry Line) by Data Adapters Only 9-28. Maintaining the Journal Entry Tables by Table Adapters 9-29. Viewing All Transactions for a Selected Account: Use of Data Reader 9-30. Obtaining Account Transaction Totals Through Stored Procedure: Use of Data Reader and Data Table
9-31. Obtaining Trial Balance Through Stored Procedure 9-32. Exploring DB schemata with dataset and data relation 9-33. Creating DB Tables

 

Last change: February 13 2016 18:47:33.