ch12 - Microsoft Visual Basic 2008: Reloaded Third Edition...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Microsoft Visual Basic 2008: Reloaded Third Edition Chapter Twelve Working with Access Databases and LINQ Microsoft Visual Basic 2008: Reloaded, Third Edition 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 Customize a DataGridView control Microsoft Visual Basic 2008: Reloaded, Third Edition 3 Objectives (continued) Handle errors using the TryCatch statement Position the record pointer in a dataset Query a dataset using LINQ Use the LINQ aggregate methods Microsoft Visual Basic 2008: Reloaded, Third Edition 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 2008: Reloaded, Third Edition 5 Database Terminology (continued) Figure 12-1: Example of a one-table relational database Microsoft Visual Basic 2008: Reloaded, Third Edition 6 Database Terminology (continued) Parent table : contains a primary key Child table : contains a foreign key from the parent table to link the tables Foreign key : field in a table that contains the primary key of another table Relational database advantages: Less redundancy Fast retrieval Ability to selectively retrieve data Microsoft Visual Basic 2008: Reloaded, Third Edition 7 Database Terminology (continued) Figure 12-2: Example of a two-table relational database Microsoft Visual Basic 2008: Reloaded, Third Edition 8 Connecting an Application to a Microsoft Access Database Microsoft Access 2007 database : Has a file extension of .accdb Must connect an application to the database before the application can access the data Use the Data Source Configuration Wizard to connect to a database Dataset : copy of the fields and records stored in the computers internal memory, which the application can access Microsoft Visual Basic 2008: Reloaded, Third Edition 9 Connecting an Application to a Microsoft Access Database (continued) Figure 12-3: Data contained in the tblEmploy table Microsoft Visual Basic 2008: Reloaded, Third Edition 10 Connecting an Application to a Microsoft Access Database (continued) Figure 12-4: How to connect an application to a Microsoft Access database Microsoft Visual Basic 2008: Reloaded, Third Edition 11 Connecting an Application to a Microsoft Access Database (continued) Figure 12-5: Data Source Configuration Wizard dialog box Microsoft Visual Basic 2008: Reloaded, Third Edition...
View Full Document

This note was uploaded on 03/05/2010 for the course CIS 2656 taught by Professor Marvpelot during the Winter '08 term at Oakland CC.

Page1 / 66

ch12 - Microsoft Visual Basic 2008: Reloaded Third Edition...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online