Select(WheredB) Method

The select method allows you to query the file and return the selected records in the file.

Syntax

public ArrayList Select( 
   WheredB whereObject
)

Parameters

whereObject: A WheredB instance the defines selection criteria.

Return Value

An ArrayList of records from the data file.

Remarks

The WheredB object defines the clause to use when selecting the rquried rows from the database table.

Example

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))
{

}

Requirements

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

Reference

DBAccess Class
DBAccess Members
Overload List