DBConnHelper Class

Helper Class for DBSheetCreateForm and AdHocSQL

Inheritance Hierarchy

Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)

Syntax

public class DBConnHelper

The DBConnHelper type exposes the following members.

Constructors

ClassSummary
public constructorDBConnHelper(String)

Methods

NameSummary
public methodgetCommand(String)
get the specific command object for commandText (SqlCommand, OleDbCommand or OdbcCommand), depending on type of connection
public methodopenConnection(String, Boolean)
opens a database connection with active connection string
private methodsetConnectionString()
set the dbSheet connection string, used in initialization and openConnection

Fields

NameDescription
public fieldDBenv
the environment of the DBConnHelper
public fieldDBGetAllFieldName
field-name where databases are returned by dbGetAllStr
public fielddbGetAllStr
statement/procedure to get all databases in a DB instance
public fielddbidentifier
identifier needed to fetch database from connection string (e.g Database=)
public fielddbPwdSpec
identifier needed to put password into connection string (e.g PWD=)
public fielddbshcnn
the DB connection for the dbsheet definition/AdHocSQL activities
public fielddbsheetConnString
the connection string for dbsheet definitions, different from the normal one (extended rights for schema viewing required)