Select() Method

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

Syntax

public ArrayList Select()

Return Value

An ArrayList of records from the data file.

Example

This examples show how to perform basic selection processing from the table.

Symphony.dB.DBAccess itemAccess = new DBAccess("ITEM", "DATABASE:DatabaseManager");
foreach (string item in itemAccess.Select())
{

}

This example demonstrates how to restrict the data being returned from the table by providing a comma separated list of field names.

Symphony.dB.DBAccess PartAccess = new DBAccess("PART", "DATABASE:DatabaseManager");
foreach (string part in PartAccess.Select("part_code, part_description"))
{

}

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