DBaddin Namespace
Classes
| Class | Summary | |
|---|---|---|
 | AboutBox | About box: used to provide information about version/build-time and links for local help and project homepage |
| AddInEvents | AddIn Connection class, also handling Events from Excel (Open, Close, Activate) |
| AdHocSQL | User-form for ad-hoc SQL execution |
| ConfigFiles | procedures used for loading config files (containing DBFunctions and general sheet content) and building the config menu |
| ContainedStatusMsg | Provides a data structure for transporting information back from the calculation action procedure to the calling function resp. the AfterCalculate event procedure |
| CustomCommandBuilder | Custom Command builder base class for SQL Server, ODBC and OLE DB to avoid primary key problems with built-in ones derived (transposed into VB.NET) from https://www.cogin.com/articles/CustomCommandBuilder.php Copyright by Dejan_Grujic 2004. http://www.cogin.com |
| CustomOdbcCommandBuilder | Custom Command builder for ODBC class |
| CustomOleDbCommandBuilder | Custom Command builder for OleDB class |
| CustomSqlCommandBuilder | Custom Command builder for SQLServer class |
| DBAction | DBActions are used to issue DML commands defined in Cells against the database |
| DBConnHelper | Helper Class for DBSheetCreateForm and AdHocSQL |
| DBDocumentation | Simple Popup Window for displaying Database documentation |
| DBMapper | DBMappers are used to store a range of data in Excel to the database. A special type of DBMapper is the CUD DBMapper for realizing the former DBSheets |
| DBMapperErrors | Datagrid window for displaying Errors after executing DBMappers |
| DBModif | Abstraction of a DB Modification Object (concrete classes DBMapper, DBAction or DBSeqnce) |
| DBModifCreate | Dialog for creating DB Modifier configurations |
| DBModifDummy | Dummy DBModif Class for executeRefresh during externally callable executeDBModif procedure. No data, just executeRefresh(srcExtent) procedure to refresh DBMappers |
| DBModifHelper | global helper functions for DBModifiers |
| DBSeqnce | DBSequences are used to group DBMappers and DBActions and run them in sequence together with refreshing DBFunctions and executing them in transaction brackets |
| DBSheetConfig | Helper module for creation of DBSheets and DBSheet definition manipulation helpers |
| DBSheetCreateForm | Form for defining/creating DBSheet definitions |
| DBSheetDefRow | DataRow Class for DBSheetDefTable |
| DBSheetDefTable | DataTable Class for filling DBSheetCols DataGridView |
| EditDBModifDef | Dialog used to display and edit the CustomXMLPart utilized for storing the DBModif definitions, and the three parts of DBAddin settings (Addin level, user and central) |
| Functions | Contains the public callable DB functions and helper functions |
| Globals | Global functions for DB Addin |
| Logging | Logging variables and functions for DB Addin |
| MenuHandler | handles all Menu related aspects (context menu for building/refreshing, "DBAddin"/"Load Config" tree menu for retrieving stored configuration files, etc.) |
| MenuHandlerGlobals | global ribbon variable and procedures for MenuHandler |
| ProgressForm | Simple Form for displaying progress in DB Modifiers (DBMapper and DBAction) instead of Excel Statusbar |
| SettingsTools | Global variables/functions for settings access |
| SupportingTools | Tools repairLegacyFunctions, checkpurgeNames and fixOrphanedDBFunctions |