Faster Smarter Beginning Programming

Key Points

• A database is a collection of data organized so that computer programs can readily access, manage, and update its contents.

• Most modern databases consist of tables. The rows in each table act as records and the columns as fields. Databases of this type are relational databases.

• Relational databases receive commands in a syntax called Structured Query Language (SQL).

• The most common types of SQL statements are:

  • SELECT (for retrieving data)

  • INSERT (for creating a new row)

  • UPDATE (for updating one or more rows)

  • DELETE (for deleting one or more rows)

• ActiveX Data Object (ADO).NET is the component most .NET programs use for accessing databases.

• ADO.NET requires a connection object for each database it accesses.

• ADO command objects store ...