Symphony Framework
Select(WheredB) Method
Symphony.dB Namespace > DBAccess Class > Select Method : Select(WheredB) Method
A WheredB instance the defines selection criteria.
The select method allows you to query the file and return the selected records in the file.
public ArrayList Select( 
   WheredB whereObject


A WheredB instance the defines selection criteria.

Return Value

An ArrayList of records from the data file.
The WheredB object defines the clause to use when selecting the rquried rows from the database table.
This example demonstrates how to apply a where caluse to a select to filter the results from the database.
Symphony.dB.DBAccess itemAccess = new DBAccess("ITEM", "DATABASE:DatabaseManager");
WheredB clause = new WheredB();
clause.Add("part_description", WheredBConditions.Contains, "GOLD");
foreach (string item in itemAccess.Select(clause))

This example filters the results from the database and limits the column/fields returned.
Symphony.dB.DBAccess PartAccess = new DBAccess("PART", "DATABASE:DatabaseManager");
WheredB fieldClause = new WheredB();
fieldClause.Add("part_description", WheredBConditions.Contains, "GOLD");
foreach (string part in PartAccess.Select("part_code, part_description", fieldClause))


Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also


DBAccess Class
DBAccess Members
Overload List