by Allan V. Pelayo (1 Submission)
Category: Databases/Data Access/DAO/ADO
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: 
(4 Votes)
This is a way of expressing my sincerest thanks (to all Developers who contributed and continously
sharing their ideas to VB community) by providing at least one sample appplication that would give an idea
to Beginners as well as in the Intermediate level of Database programming of what an N-Tier application is all
about. This is a transaction oriented-application (see your SQl Profiler)capable of accessing database through stored procedures and without single
Adhoc queries involved. Business rules were implemented through the middle layer which you can compile as in process dll at anytime
and used it by setting the reference and instantiate to exposed its objects. An option to change your connection has been
included during logon to allow user to change database connection. All exeptions are handled by error trapping code so don't
worry about unexpected closing of application. I have also added some crystal report functionality and show how to use
TTX files(Field Definitions Only) on stored procedure. Should there be any bug occured during runtime, please send the details to me. Thanks and Please vote.
Download Production Report(A 3-Tired Application using ADO (1010 KB)
VBcoders