| A | B |
|---|
| database | an organized collection of related information stored in a file on a disk |
| relational database | a database taht stores information in tables, which are composed of coulmns (fields) and rows (records) |
| field | a single item of information about a person, place or thing |
| record | a group of related fields that contain all of the necessary data about a specific person, place, or thing |
| table | a group of related records |
| primary key | the field that uniquely identifies each record in a table |
| parent table | a table to which another table, called a child table, links |
| foreign key | the common field in a child table |
| ADO.NET 2.0 | refers to the technology used in Visual Basic 2005 to connect an application to a database |
| dataset | a coy of some or all of the records and fields contained in a database; stored in the computer's internal memory |
| Binding | refers to the process of connecting a dataset object to a control on a form |
| bound controls | controls connected to a dataset object |
| DataSet object | stores the information contained in a dataset |
| Update method | commits, to the database, the changes made to the dataset |
| Fill method | used to load data into a table contained in a dataset |
| Position property | used by the BindingSource object to store the position of the record pointer |
| query | specifies the fields and records to retrieve from a database, as well as the order in which to arrange the fields and records |
| SQL | stands for Structured Query Language; a set of commands that allows you to access and manipulate the data stored in databases |
| SELECT statement | t commonly used SQL command; allows you to specify the fields and records you want to access from a database, as well as control the order in which the fields and records appear when displayed |
| WHERE clause | used in a SELECT statement to control the order in which the records are arranged |
