DBaddin Namespace

Classes

ClassSummary
public classAboutBox
About box: used to provide information about version/build-time and links for local help and project homepage
public classAddInEvents
AddIn Connection class, also handling Events from Excel (Open, Close, Activate)
public classAdHocSQL
User-form for ad-hoc SQL execution
public classCheckInstance
public classConfigFiles
procedures used for loading config files (containing DBFunctions and general sheet content) and building the config menu
public classContainedStatusMsg
Provides a data structure for transporting information back from the calculation action procedure to the calling function resp. the AfterCalculate event procedure
public classCustomCommandBuilder
public classCustomOdbcCommandBuilder
Custom Command builder for ODBC 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
public classCustomOleDbCommandBuilder
Custom Command builder for OleDB 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
public classCustomSqlCommandBuilder
Custom Command builder for SQLServer 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
public classDBAction
DBActions are used to issue DML commands defined in Cells against the database
public classDBConnHelper
Helper Class for DBSheetCreateForm and AdHocSQL
public classDBMapper
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
public classDBModif
Abstraction of a DB Modification Object (concrete classes DBMapper, DBAction or DBSeqnce)
public classDBModifCreate
Dialog for creating DB Modifier configurations
public classDBModifDummy
public classDBModifs
global helper functions for DBModifiers
public classDBSeqnce
DBSequences are used to group DBMappers and DBActions and run them in sequence together with refreshing DBFunctions and executing them in transaction brackets
public classDBSheetConfig
Helper module for easier manipulation of DBSheet definition
public classDBSheetCreateForm
Form for defining/creating DBSheet definitions
public classDBSheetDefRow
DataRow Class for DBSheetDefTable
public classDBSheetDefTable
DataTable Class for filling DBSheetCols DataGridView
public classEditDBModifDef
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)
public classFunctions
Contains the public callable DB functions and helper functions
public classGlobals
Global functions for DB Addin
public classLogging
Logging variables and functions for DB Addin
public classMenuHandler
handles all Menu related aspects (context menu for building/refreshing, "DBAddin"/"Load Config" tree menu for retrieving stored configuration files, etc.)
public classMenuHandlerGlobals
global ribbon variable and procedures for MenuHandler
public classSettingsTools
Global setting variables/functions and repairLegacyFunctions and checkpurgeNames tools