C# Class SharpPlant.DbMethods

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