Other Tutorials
|
Microsoft ActiveX Data Objects, ADO, is a
library used to create and manage computer databases for the
Microsoft Windows family of operating systems. The library can be
used to connect to various types of databases, including Microsoft
Access, Paradox, Microsoft SQL Server, text files, Microsoft
Excel, etc.
This web site features lessons, articles, and
links on using ADO. The lessons on this site were created using
Microsoft Visual Basic Express. aaa
|
Introduction
to Record Sets |
A record set is the center of an ADO
database. This is an introduction on how to create it using
the RecordsetClass class of the ADODB
namespace.
|
Introduction to
SQL |
The Structured Query Language (SQL) is the
most universal language used by database environments. This
is an introduction to its implementation in Microsoft JET.
|
Record
Maintenance
|
This is review of editing or deleting
records using the SQL. The operators or keywords include UPDATE
and DELETE.
|
Record
Navigation
|
Record navigation consists of moving among
records of a recordset. Before doing this, you must create a
recordset and specify the type of cursor you will use. When
implementing the navigation, you must specify what Windows
control would display the values of what column.
|
|
|
|
|