C# Class SharpPlant.DbMethods

Afficher le fichier Open project: phusband/SharpPlant

Méthodes publiques

Méthode Description
AddDbField ( string dbPath, string tableName, string fieldName, string fieldType ) : bool
GetDbDataSet ( string dbPath, IEnumerable tables ) : DataSet
GetDbImage ( object imageField ) : Image
GetDbTable ( string dbPath, string tableName ) : DataTable
UpdateDbRow ( string dbPath, DataRow row ) : bool
UpdateDbTable ( string dbPath, DataTable inputTable ) : bool

Private Methods

Méthode Description
CheckOpenConnection ( System.Data.OleDb.OleDbConnection connection ) : void
GetAddFieldCommand ( string tableName, string fieldName, string fieldType, System.Data.OleDb.OleDbConnection connection ) : OleDbCommand
GetConnection ( string dbPath ) : System.Data.OleDb.OleDbConnection
GetConnection ( string dbPath, ConnectionType type ) : System.Data.OleDb.OleDbConnection
GetOleDbType ( Type inputType ) : OleDbType
GetSelectCommand ( string tableName, System.Data.OleDb.OleDbConnection connection ) : OleDbCommand
GetUpdateCommand ( DataRow row, System.Data.OleDb.OleDbConnection connection ) : OleDbCommand
GetUpdateCommand ( DataTable inputTable, object rowFilter, System.Data.OleDb.OleDbConnection connection ) : OleDbCommand

Method Details

AddDbField() public static méthode

public static AddDbField ( string dbPath, string tableName, string fieldName, string fieldType ) : bool
dbPath string
tableName string
fieldName string
fieldType string
Résultat bool

GetDbDataSet() public static méthode

public static GetDbDataSet ( string dbPath, IEnumerable tables ) : DataSet
dbPath string
tables IEnumerable
Résultat System.Data.DataSet

GetDbImage() public static méthode

public static GetDbImage ( object imageField ) : Image
imageField object
Résultat Image

GetDbTable() public static méthode

public static GetDbTable ( string dbPath, string tableName ) : DataTable
dbPath string
tableName string
Résultat System.Data.DataTable

UpdateDbRow() public static méthode

public static UpdateDbRow ( string dbPath, DataRow row ) : bool
dbPath string
row System.Data.DataRow
Résultat bool

UpdateDbTable() public static méthode

public static UpdateDbTable ( string dbPath, DataTable inputTable ) : bool
dbPath string
inputTable System.Data.DataTable
Résultat bool