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.
<<PreviousNext>>

9.2   ADO.NET Concepts

ADO.NET (ActiveX Data Objects Dot Net) provides a uniform set of objects that you can use to work with various kinds of databases. This chapter focuses only on the use of ADO.NET to handle the MS Access database as an introduction to database and to the ADO.NET technology.
Figure 9-1 shows an overview of how an MS database (DB) interacts with the outside world. Most likely, your previous experiences with the MS Access DB are through a direct interaction with the MS Access software, the database management system (DBMS). The figure indicates that the MS Access database is managed by the MS Access (program), which also interacts with other software systems (such as ADO.NET). The Connection object serves as a bridge for other ADO.NET objects to connect and interact with the DBMS. Most of the data manipulations are performed with data command objects through the connection object. In VB.NET, data are stored in data tables, which can belong in, or be independent of, a dataset. Data in datasets and data tables can be built internally by your program or obtained from an external data source (e.g., MS Access DB) through the data adapter or table adapter, which has various data commands at its disposal. As you can infer from the figure, data commands can also be created and used, independent of the data adapter or table adapter.

Figure 9-1
ADO.NET Objects and Their Data Source

Last change: February 13 2016 18:47:31.
  1. Table Definitions
  2. Indexes, the Primary Key, and the Foreign Key
  3. Introduction to the SQL
  • 9.2 ADO.NET Concepts
    1. Dataset, Data Table, Data Row, and Data Column
    2. The Connection, Data Command, Data Adapter, and Table Adapter
    3. <<PreviousNext>>