by Frank Kusluski (19 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: (13 Votes)
My third submission to vbcoders.com demonstrates
how to use ADO and the Datagrid Control together.
One neat feature of this app is the use of a
horizontal scroll bar to move through records. I
haven't thoroughly tested this app so don't be
surprised if you find a couple bugs. If you're new
to ADO or even a novice I'm sure you'll find
something useful in this app. Please vote and
give me some feedback!
Inputs
None.
Assumes
This app uses the Access database file BIBLIO.MDB
that is shipped with VB. You may need to change
the ConnectionString property of the Adodc Control
to reflect the directory where BIBLIO.MDB resides
on your machine. On most PCs it can be found on
the C drive.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Program Files\Microsoft Visual Studio\VB98\Biblio.mdb;Persist Security Info=False
Code Returns
None.
Side Effects
None that I know of.
API DeclarationsNone.
Download ADO and Datagrid Sample w/Horizontal Scrollbar (6 KB)