DLADatabase

Communication with a database via oledb

@remark

Package DLAFormfactory
Author Bert Dingemans
Alias --
Stereotypes --

Attributes

Name Type Cardinality Description
strConnection String 1 - 1--
strDataBase String 1 - 1--
objCon DbConnection 1 - 1ConfigurationManager.AppSettings("database").ToUpper()
strErrorMessage String 1 - 1--
objTrans DbTransaction 1 - 1--
strStatement String 1 - 1--
blnTransaction Boolean 1 - 1--
blnSupplierIsReader Boolean 1 - 1--

Methods

Name Type Description
ExecuteSupply DLASupplierExecute a sql as a selectstatement and return a data supplier

@returns
ExecuteSupply DLASupplierExecute a sql statement and transform to a supplier

@returns
@remark
DefaultSql StringProcess the sql statement to a standard so that the --s are handled correctly

@returns
@remark
CloseConnection --Close an open databaseconnection

@remark
OpenConnection --Open a connection to the database

@remark
ExecuteModify Booleanexecute a Data Manipulation (insert/update/delete) statement

@returns
SQL2DataTable DataTableExecute a Data Retrieve statement and return it as a datatable

@returns
@remark
GetErrorMessage StringRetrieve any stacked error messages

@returns
@remark
ClearError --Opnieuw een statement uitvoeren dus eerst de foutenlog clearen

@remark
SupplierIsReader --Indicates whether the DLASupplier is a datareader instead of a dataset

@remark
SupplierIsDataSet --Indicates whether the DLASupplier is a dataset instead of a datareader

@remark
New --Instantiate the database object with a connectionstring
New --Instantiate database object

@remark
SetConnection --Set the connection string for the database
MakeConnection --Make connection to a database

@remark
IsMSAccess BooleanIs it an access database that is connected this makes some sql statements different like wildcards

@returns
@remark
GetConnectionString StringGet the active connectionstring

@returns
@remark
IsOleDB BooleanIs the sql connection an oledb connection

@returns True when an oledb connection

Diagrams

DLAFormfactory

--

Linked elements

DLAFormfactory