Chapter 10 Key Terms

1
Chapter 10 Key Terms

• and more.

2
DBMS
Database Terms

• We will use Microsoft Access as our database
  management system.
• What is a database management system?
• Add and delete records
• Edit records
• Sort records
• Query the database records
• Generate reports from the database records

3
The Visual Basic connection
Database Terms

• You can write applications in VB that can access
  database files.
• display
• update
• Active X Data Objects. (ADO)
• data is stored and transferred in XML
• all text system
• ADO is compatible with many database formats.

4
Table
Database Terms

• Allows database to be read as a spreadsheet.
• Each ROW represents the data for one RECORD.
• A record exists for one item of interest such as
  a person or other item.
• Each COLUMN holds an element of data (field)
  corresponding to each record.
• See Figure 10.1 in the text.

5
Key Field
Database Terms

• One or more fields that identify a unique record
  in the database.
• Often an identification number
• Student number
• Account number
• License number

6
Relationships
Database Terms

• Multiple tables in a database are may be related.
  
• The key fields relate one table to another.
• Keeps the data compact by avoiding duplication of
  data.
• Facilitates updates to the records.

7
The current record
Database Terms

• the record that has the focus is the current
  record.
• Every DBMS has a means for changing (navigating)
  the current record.

8
XML

• eXtensible Markup Language
• Data stored in the XML format is all text
• passes through firewalls
• edited by any text editor like Notepad
• When needed for Web applications, VB generates
  the XML using ADO.NET

9
ADO.NET

• Active X Data Objects
• Information is stored and transferred in XML
• Adaptable to many data formats including SQL
• SQL is a Microsoft DBMS particularly suited to
  Web based databases.

10
Data Access Controls
Developing the application

• See the DataGridView control in Figure 10.2
• Binding the DataGridView control or any other
  display control to a database makes the data
  visible.
• Labels and textboxes can also be used to display
  database data.

11
A Data Source File

• Produced by a DBMS
• The data sources are listed for you in VB2005
  Data Sources window or VB2003 Server Explorer
  (ToolsgtConnect to Database)

12
A Binding Source Object
Developing the application

• Links the VB program to a specific file or
  database
• Binding source is a VB2005 term meaning
  connection object in VB2003
• Quires (SQL) and updates the DataSouuce
• In my examples OleDb.

see Figure 10.3 for a graphical representation of
moving data from a database file to your
application.
13
Table Adapters
Developing the application

• Passes data back and forth from the data source
  and your program.
• It uses the Binding Source Object to "talk" to
  the database.
• It uses the Dataset in your program to "talk" to
  the controls on your form.
• In my VB2003 examples OleDb.OleDbDataAdapter()

14
Dataset
Developing the application

• This is the data in a form that you can display
  and manipulate.
• In my VB2003 examples it is a DataTable object
• imagine a spreadsheet
• each row is a record
• the fields of every record are stored in columns

15
DataGrid control
Developing the application

• Displays the data table in a flat spreadsheet
  format.
• In VB2003 DataGrid.SetBindingData fills the
  DataGrid control.