C# Class DAL.SQLiteDatabase

Datei anzeigen Open project: siracoj/signtolearn Class Usage Examples

Public Methods

Method Description
ClearDB ( ) : bool
ClearTable ( String table ) : bool
Delete ( String tableName, String where ) : bool
ExecuteNonQuery ( string sql ) : int
ExecuteScalar ( string sql ) : string
GetDataTable ( string sql ) : DataTable
Insert ( String tableName, String>.Dictionary data ) : bool
SQLiteDatabase ( ) : System
Update ( String tableName, String>.Dictionary data, String where ) : bool

Method Details

ClearDB() public method

public ClearDB ( ) : bool
return bool

ClearTable() public method

public ClearTable ( String table ) : bool
table 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 ) : int
sql string
return int

ExecuteScalar() public method

public ExecuteScalar ( string sql ) : string
sql string
return string

GetDataTable() public method

public GetDataTable ( string sql ) : DataTable
sql string
return System.Data.DataTable

Insert() public method

public Insert ( String tableName, String>.Dictionary data ) : bool
tableName String
data String>.Dictionary
return bool

SQLiteDatabase() public method

public SQLiteDatabase ( ) : System
return System

Update() public method

public Update ( String tableName, String>.Dictionary data, String where ) : bool
tableName String
data String>.Dictionary
where String
return bool