Overview
DBAddin has three main areas and the Addin global code area, which are mapped to the following source files:
DB Functions and their config files
- Functions.vb - Contains the public callable DB functions and helper functions and a data structure for transporting information back from the calculation action procedure to the calling function
- ConfigFiles.vb - procedures used for loading config files (containing DBFunctions and general sheet content) and building the config menu
DB Modifiers
- DBModif.vb - DBModif Class: Abstraction of a DB Modification Object and descendant concrete classes DBMapper, DBAction or DBSeqnce; also contains global helper functions for DBModifiers and an abstract helper class CustomCommandBuilder for building Insert/Update/Delete Statements for DBMapper having concrete implementations in CustomSqlCommandBuilder, CustomOleDbCommandBuilder and CustomOdbcCommandBuilder.
- DBModifCreate.vb - Dialog for creating DB Modifier configurations
- EditDBModifDef.vb - Dialog used to display and edit the CustomXMLPart utilized for storing the DBModif definitions, reused to also show DBAddin settings
DBSheet definition creation and assignment
- DBSheetConfig.vb - Helper module for easier manipulation of DBSheet definition
- DBSheetCreateForm.vb - Form for defining/creating DBSheet definitions
- DBConnHelper.vb - connection helper class (Connection configuration data) used for DBSheetCreateForm.vb and AdHocSQL.vb
Addin global code
- Globals.vb - Global variables and functions for DB Addin
- MenuHandler.vb - handles all Menu related aspects (context menu for building/refreshing, "DBAddin"/"Load Config" tree menu for retrieving stored configuration files, etc.)
- AboutBox.vb - About box: used to provide information about version/buildtime and links for local help and project homepage
- AddInEvents.vb - AddIn Connection class, also handling Events from Excel (Open, Close, Activate)
- AdHocSQL.vb - Issuing adhoc SQL Commands from a dialog box