Class DBConnHelper
Helper Class for DBSheetCreateForm and AdHocSQL
Inheritance
System.Object
DBConnHelper
Namespace: DBaddin
Assembly: DBaddin.dll
Syntax
public class DBConnHelper
Constructors
| Improve this Doc View SourceDBConnHelper(String)
Declaration
public DBConnHelper(string passedEnv)
Parameters
Name | Description |
---|---|
passedEnv |
Fields
| Improve this Doc View SourceDBenv
the environment of the DBConnHelper
Declaration
public string DBenv
Field Value
Description |
---|
DBGetAllFieldName
field-name where databases are returned by dbGetAllStr
Declaration
public string DBGetAllFieldName
Field Value
Description |
---|
dbGetAllStr
statement/procedure to get all databases in a DB instance
Declaration
public string dbGetAllStr
Field Value
Description |
---|
dbidentifier
identifier needed to fetch database from connection string (e.g Database=)
Declaration
public string dbidentifier
Field Value
Description |
---|
dbPwdSpec
identifier needed to put password into connection string (e.g PWD=)
Declaration
public string dbPwdSpec
Field Value
Description |
---|
dbshcnn
the DB connection for the dbsheet definition activities
Declaration
public DbConnection dbshcnn
Field Value
Description |
---|
dbsheetConnString
the connection string for dbsheet definitions, different from the normal one (extended rights for schema viewing required)
Declaration
public string dbsheetConnString
Field Value
Description |
---|
Methods
| Improve this Doc View SourcegetCommand(String)
Declaration
public DbCommand getCommand(string commandText)
Parameters
Name | Description |
---|---|
commandText |
Returns
Description |
---|
openConnection(String, Boolean)
opens a database connection with active connection string
Declaration
public void openConnection(string databaseName = "", bool usedForDBSheetCreate = false)
Parameters
Name | Description |
---|---|
databaseName | |
usedForDBSheetCreate |