GetData¶

Executes a query using the specified column and value as a single criterion, and returns the resulting DataTable instance.

1

$Database.GetData(schema: string, table: string, column: string, value: any):DataTable

Executes a query using a specific column and value as criteria and returns the resulting data table instance.

1

$Database.GetData(store: string, schema: string, table: string, column: string, value: any):DataTable

Parameters¶

string schema
    The name of the target schema.

string table
    The name of the target table.

string column
    The name of the column to use as criteria.

any value
    The value of the column to use as criteria.

string store
    The name or ID of the target data store. This parameter is optional.

Returns¶

A DataTable instance containing the query results.

Remarks¶

If no rows match, the return value is an empty data table.

Example¶

1

var table = $Database.GetData("MySchema", "MyTable", "Id", $Xml.Evaluate('Id'));

Example¶

1

var table = $Database.GetData("MySchema", "MyTable", "Id", $Xml.Evaluate('Id'));

See Also¶

• DataTable