C# Class IBE.Enums_and_Utility_Classes.DataRetriever

retriever class

Inheritance: IDataPageRetriever

Mostra file Open project: Duke-Jones/ED-IBE Class Usage Examples

Public Methods

Method	Description
DataRetriever ( SQL DBCon, string BaseTableName, string columnStatement, String baseStatement, String SortByColumn, DBConnector SortOrder, DataTable TypeTable = null ) : System	constructor for the DataRetriever (used for loading and caching data in DGV VirtualMode)
GetWhereStatement ( string ignoreFilter = "" ) : String
RowCount ( System.Boolean refresh = false ) : int
SupplyPageOfData ( int lowerPageBoundary, int rowsPerPage ) : DataTable

Private Methods

Method	Description
CommaSeparatedListOfColumnNames ( String Prefix = "" ) : string
GetDataTable ( ) : DataTable
SetFilter ( string name, string filterString ) : void

Method Details

DataRetriever() public method

constructor for the DataRetriever (used for loading and caching data in DGV VirtualMode)

public DataRetriever ( SQL DBCon, string BaseTableName, string columnStatement, String baseStatement, String SortByColumn, DBConnector SortOrder, DataTable TypeTable = null ) : System
DBCon	SQL	used DBConnector
BaseTableName	string
columnStatement	string
baseStatement	String
SortByColumn	String	column for sorting (must be existingClassification in the base table (m_BaseTableName) and in the 'DataStement')
SortOrder	DBConnector	sort oder
TypeTable	System.Data.DataTable
return	System

GetWhereStatement() public method

public GetWhereStatement ( string ignoreFilter = "" ) : String
ignoreFilter	string
return	String

RowCount() public method

public RowCount ( System.Boolean refresh = false ) : int
refresh	System.Boolean
return	int

SupplyPageOfData() public method

public SupplyPageOfData ( int lowerPageBoundary, int rowsPerPage ) : DataTable
lowerPageBoundary	int
rowsPerPage	int
return	System.Data.DataTable