C# Class TestME.DB

ファイルを表示 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