C# Class IBE.Enums_and_Utility_Classes.DataRetriever

retriever class

Inheritance: IDataPageRetriever

Afficher le fichier Open project: Duke-Jones/ED-IBE Class Usage Examples

Méthodes publiques

Méthode	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

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

Method Details

DataRetriever() public méthode

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
Résultat	System

GetWhereStatement() public méthode

public GetWhereStatement ( string ignoreFilter = "" ) : String
ignoreFilter	string
Résultat	String

RowCount() public méthode

public RowCount ( System.Boolean refresh = false ) : int
refresh	System.Boolean
Résultat	int

SupplyPageOfData() public méthode

public SupplyPageOfData ( int lowerPageBoundary, int rowsPerPage ) : DataTable
lowerPageBoundary	int
rowsPerPage	int
Résultat	System.Data.DataTable