Show / Hide Table of Contents

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 Source

DBConnHelper(String)

Declaration
public DBConnHelper(string passedEnv)
Parameters
Name Description
passedEnv

Fields

| Improve this Doc View Source

DBenv

the environment of the DBConnHelper

Declaration
public string DBenv
Field Value
Description
| Improve this Doc View Source

DBGetAllFieldName

field-name where databases are returned by dbGetAllStr

Declaration
public string DBGetAllFieldName
Field Value
Description
| Improve this Doc View Source

dbGetAllStr

statement/procedure to get all databases in a DB instance

Declaration
public string dbGetAllStr
Field Value
Description
| Improve this Doc View Source

dbidentifier

identifier needed to fetch database from connection string (e.g Database=)

Declaration
public string dbidentifier
Field Value
Description
| Improve this Doc View Source

dbPwdSpec

identifier needed to put password into connection string (e.g PWD=)

Declaration
public string dbPwdSpec
Field Value
Description
| Improve this Doc View Source

dbshcnn

the DB connection for the dbsheet definition activities

Declaration
public DbConnection dbshcnn
Field Value
Description
| Improve this Doc View Source

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 Source

getCommand(String)

Declaration
public DbCommand getCommand(string commandText)
Parameters
Name Description
commandText
Returns
Description
| Improve this Doc View Source

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
  • Improve this Doc
  • View Source
Back to top Generated by DocFX