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)
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)