by Martins Skujenieks (5 Submissions)
Category: Databases/Data Access/DAO/ADO
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating:
(9 Votes)
This is a small application that uses ADODC control to connect to Access, Excel etc. ODBC data sources and execute SQL statement on them. The DataGrid control are used to display returned data.
The application has it's own simple SQL code keyword formatter, logging and other features. Small, efficient and robust.
Could be a good example of how to use ADO object to connect to DB, execute SQL queries against data in DB and handle the returned data.
Download ADO Data Provider (56 KB)