720 likes | 1.17k Views
Objectives. After studying this chapter, you should be able to:Define the terms used when talking about databasesConnect an application to a Microsoft Access databaseBind table and field objects to controlsExplain the purpose of the DataSet, BindingSource, TableAdapter, TableAdapterManager, and
E N D
1. Microsoft Visual Basic 2010: Reloaded Fourth Edition Chapter Twelve
Access Databases and LINQ
2. Objectives After studying this chapter, you should be able to:
Define the terms used when talking about databases
Connect an application to a Microsoft Access database
Bind table and field objects to controls
Explain the purpose of the DataSet, BindingSource, TableAdapter, TableAdapterManager, and BindingNavigator objects Microsoft Visual Basic 2010: Reloaded, Fourth Edition 2
3. Objectives (cont'd.) Customize a DataGridView control
Handle errors using the TryCatch statement
Position the record pointer in a dataset
Access the value stored in a field object
Query a dataset using LINQ
Customize a BindingNavigator control
Use the LINQ aggregate methods Microsoft Visual Basic 2010: Reloaded, Fourth Edition 3
4. Database Terminology Computer database: electronic file containing an organized collection of related information
Relational database: database that stores information in tables composed of columns and rows
Field: single item of information
Record: group of related fields
Table: group of related records
Primary key: field that uniquely identifies each record Microsoft Visual Basic 2010: Reloaded, Fourth Edition 4
5. Database Terminology (cont'd.) Microsoft Visual Basic 2010: Reloaded, Fourth Edition 5