C# Class SharpPlant.DbMethods

Datei anzeigen Open project: phusband/SharpPlant

Public Methods

Method 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

Method 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 method

public static AddDbField ( string dbPath, string tableName, string fieldName, string fieldType ) : bool
dbPath string
tableName string
fieldName string
fieldType string
return bool

GetDbDataSet() public static method

public static GetDbDataSet ( string dbPath, IEnumerable tables ) : DataSet
dbPath string
tables IEnumerable
return System.Data.DataSet

GetDbImage() public static method

public static GetDbImage ( object imageField ) : Image
imageField object
return Image

GetDbTable() public static method

public static GetDbTable ( string dbPath, string tableName ) : DataTable
dbPath string
tableName string
return System.Data.DataTable

UpdateDbRow() public static method

public static UpdateDbRow ( string dbPath, DataRow row ) : bool
dbPath string
row System.Data.DataRow
return bool

UpdateDbTable() public static method

public static UpdateDbTable ( string dbPath, DataTable inputTable ) : bool
dbPath string
inputTable System.Data.DataTable
return bool