C# Class Schumix.Framework.Database.MySql

Datei anzeigen Open project: Schumix/Schumix2 Class Usage Examples

Public Methods

Method Description
Delete ( string sql ) : bool
Delete ( string TableName, string Where ) : bool
ExecuteNonQuery ( string sql, bool logerror = true ) : void
Insert ( string sql ) : bool
Insert ( string TableName, string Values ) : bool
IsCreatedTable ( string Table ) : bool
MySql ( string host, int port, string username, string password ) : System
MySql ( string host, int port, string username, string password, string database ) : System
MySql ( string host, int port, string username, string password, string database, string charset ) : System
MySql ( string username, string password ) : System
MySql ( string host, string username, string password ) : System
MySql ( string host, string username, string password, string database ) : System
MySql ( string host, string username, string password, string database, string charset ) : System
Query ( string query, bool logerror = true ) : DataTable
QueryFirstRow ( string query ) : DataRow
RemoveTable ( string Table ) : bool
Update ( string sql ) : bool
Update ( string TableName, string Set ) : bool
Update ( string TableName, string Set, string Where ) : bool

Private Methods

Method Description
Crash ( MySql.Data.MySqlClient.MySqlException m, bool logerror, bool c = false ) : void
Initialize ( string host, int port, string username, string password, string database, string charset ) : bool
IsConnect ( ) : void

Method Details

Delete() public method

public Delete ( string sql ) : bool
sql string
return bool

Delete() public method

public Delete ( string TableName, string Where ) : bool
TableName string
Where string
return bool

ExecuteNonQuery() public method

public ExecuteNonQuery ( string sql, bool logerror = true ) : void
sql string
logerror bool
return void

Insert() public method

public Insert ( string sql ) : bool
sql string
return bool

Insert() public method

public Insert ( string TableName, string Values ) : bool
TableName string
Values string
return bool

IsCreatedTable() public method

public IsCreatedTable ( string Table ) : bool
Table string
return bool

MySql() public method

public MySql ( string host, int port, string username, string password ) : System
host string
port int
username string
password string
return System

MySql() public method

public MySql ( string host, int port, string username, string password, string database ) : System
host string
port int
username string
password string
database string
return System

MySql() public method

public MySql ( string host, int port, string username, string password, string database, string charset ) : System
host string
port int
username string
password string
database string
charset string
return System

MySql() public method

public MySql ( string username, string password ) : System
username string
password string
return System

MySql() public method

public MySql ( string host, string username, string password ) : System
host string
username string
password string
return System

MySql() public method

public MySql ( string host, string username, string password, string database ) : System
host string
username string
password string
database string
return System

MySql() public method

public MySql ( string host, string username, string password, string database, string charset ) : System
host string
username string
password string
database string
charset string
return System

Query() public method

public Query ( string query, bool logerror = true ) : DataTable
query string
logerror bool
return System.Data.DataTable

QueryFirstRow() public method

public QueryFirstRow ( string query ) : DataRow
query string
return System.Data.DataRow

RemoveTable() public method

public RemoveTable ( string Table ) : bool
Table string
return bool

Update() public method

public Update ( string sql ) : bool
sql string
return bool

Update() public method

public Update ( string TableName, string Set ) : bool
TableName string
Set string
return bool

Update() public method

public Update ( string TableName, string Set, string Where ) : bool
TableName string
Set string
Where string
return bool