C# Class TestME.DB

Datei anzeigen Open project: Hli4S/TestMeApp Class Usage Examples

Public Methods

Method Description
CloseConn ( ) : void
Connect ( ) : void
Connected ( ) : bool
DB ( ) : System
DB ( string connectionString ) : System
QueryStatus ( ) : bool
bind ( string fields ) : void
bind ( string field, string value ) : void
column ( string query, string bindings = null, int colN ) : List
nQuery ( string query, string bindings = null ) : int
qBind ( string fields ) : void
query ( string query, string bindings = null ) : DataTable
row ( string query, string bindings = null ) : string[]
setConnection ( string host, string user, string pass, string dbname ) : void
single ( string query, string bindings = null ) : string
table ( string table, string bindings = null ) : DataTable
table ( string table, Type t ) : List

Private Methods

Method Description
Init ( string Query, string bindings = null ) : void
execDatatable ( ) : DataTable
execNonquery ( ) : int

Method Details

CloseConn() public method

public CloseConn ( ) : void
return void

Connect() public method

public Connect ( ) : void
return void

Connected() public method

public Connected ( ) : bool
return bool

DB() public method

public DB ( ) : System
return System

DB() public method

public DB ( string connectionString ) : System
connectionString string
return System

QueryStatus() public method

public QueryStatus ( ) : bool
return bool

bind() public method

public bind ( string fields ) : void
fields string
return void

bind() public method

public bind ( string field, string value ) : void
field string
value string
return void

column() public method

public column ( string query, string bindings = null, int colN ) : List
query string
bindings string
colN int
return List

nQuery() public method

public nQuery ( string query, string bindings = null ) : int
query string
bindings string
return int

qBind() public method

public qBind ( string fields ) : void
fields string
return void

query() public method

public query ( string query, string bindings = null ) : DataTable
query string
bindings string
return System.Data.DataTable

row() public method

public row ( string query, string bindings = null ) : string[]
query string
bindings string
return string[]

setConnection() public method

public setConnection ( string host, string user, string pass, string dbname ) : void
host string
user string
pass string
dbname string
return void

single() public method

public single ( string query, string bindings = null ) : string
query string
bindings string
return string

table() public method

public table ( string table, string bindings = null ) : DataTable
table string
bindings string
return System.Data.DataTable

table() public method

public table ( string table, Type t ) : List
table string
t System.Type
return List