Ch10 - Chapter 10 Database Management 10.1 An Introduction...

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

View Full Document Right Arrow Icon
1 Chapter 10 – Database Management 10.1 An Introduction to Databases 10.2 Editing and Designing Databases
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 10.1 An Introduction to Databases Accessing a Database Table Binding to Additional Tables Querying a Table with LINQ Primary and Foreign Keys The Join of Two Tables
Background image of page 2
3 Sample Table – Cities Table
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 Sample Table – Countries Table
Background image of page 4
5 Database Terminology A table is a rectangular array of data. Each column of the table, called a field , contains the same type of information. Each row, called a record , contains all the information about one entry in the table.
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 Database Management Software (DBMS) Used to create databases Databases contain one or more related tables Examples of DBMS are Access, Oracle, and SQL Server. The databases used in this chapter are found in the folder Programs\Ch10\Databases. They were created with Access and have the extension accdb .
Background image of page 6
Megacities.accdb Contains the two tables Cities and Countries shown earlier. This database will be used extensively in the examples for this chapter. Several steps are required to bind to a table of the database. (See the next sixteen slides.) 7
Background image of page 7

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

View Full DocumentRight Arrow Icon
Binding to the Cities Table Add a BindingSource control to the form. (The control is in the Data and All Windows Forms group of the Toolbox. It appears in the form’s component tray with the name BindingSource1.) 8
Background image of page 8
DataSource Property of BindingSource1 9 click here
Background image of page 9

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

View Full DocumentRight Arrow Icon
Choose Data Source Type 10 click on Next button select
Background image of page 10
Choose Database Model 11 click on Next button select
Background image of page 11

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

View Full DocumentRight Arrow Icon
Choose Data Connection 12 click on New Connection button
Background image of page 12
Add Connection Dialog Box 13 click on Change button
Background image of page 13

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

View Full DocumentRight Arrow Icon
Change Data Source Box 14 select click on OK button
Background image of page 14
15 Add Connection Dialog Box click on Browse button
Background image of page 15

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

View Full DocumentRight Arrow Icon
Select Database File 16 double-click on Megacities.accdb
Background image of page 16
Add Connection Dialog Box 17 click on OK button
Background image of page 17

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

View Full DocumentRight Arrow Icon
Choose Data Connection 18 click on Next button
Background image of page 18
19 click on Yes button
Background image of page 19

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

View Full DocumentRight Arrow Icon
Save to File 20 check this box click on Next button
Background image of page 20
Choose Database Objects 21 check on Tables box click on Finish button
Background image of page 21

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

View Full DocumentRight Arrow Icon
Changes in Properties Window and Form 22
Background image of page 22
After Clicking on DataMember Down-Arrow 23 click on Cities
Background image of page 23

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

View Full DocumentRight Arrow Icon
VB Generated Items 24 new icon new code
Background image of page 24
Image of page 25
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/19/2012 for the course CIT 230 taught by Professor Staff during the Fall '08 term at Oakland University.

Page1 / 68

Ch10 - Chapter 10 Database Management 10.1 An Introduction...

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

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