IDEA & WPP Community
Home
Search
Keywords
Advanced search
Startpages
Download sourcecode
What is IDEA?
About the WPP
All startpages
Overview
Packages
Diagrams
Extra
Explorer
Matrix
Release notes
Glossary
Charts
Participant
Participate
Login
Contact
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 - 1
ConfigurationManager.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
DLASupplier
Execute a sql as a selectstatement and return a data supplier
@returns
ExecuteSupply
DLASupplier
Execute a sql statement and transform to a supplier
@returns
@remark
DefaultSql
String
Process 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
Boolean
execute a Data Manipulation (insert/update/delete) statement
@returns
SQL2DataTable
DataTable
Execute a Data Retrieve statement and return it as a datatable
@returns
@remark
GetErrorMessage
String
Retrieve 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
Boolean
Is it an access database that is connected this makes some sql statements different like wildcards
@returns
@remark
GetConnectionString
String
Get the active connectionstring
@returns
@remark
IsOleDB
Boolean
Is the sql connection an oledb connection
@returns True when an oledb connection
Diagrams
DLAFormfactory
--
Linked elements
DLAFormfactory
FormFactoryGenerator