SelectStatementResult.Rows Field

An array of rows that represent the result of a single select query to a data store. Each row contains the values of the queried fields. To learn more, refer to How to: Access Data in SQL Query Results.

Namespace: DevExpress.Xpo.DB

Assembly: DevExpress.Data.v24.2.dll

Declaration

C#

public SelectStatementResultRow[] Rows

VB.NET

Public Rows As SelectStatementResultRow()

Field Value

Type
DevExpress.Xpo.DB.SelectStatementResultRow[]

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Rows field.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

XAF-How-to-Implement-CRUD-Operations-for-Non-Persistent-Objects-Stored-Remotely/CS/NonPersistentObjectsDemo.Module/DataStoreMapper.cs#L68

List<DataStoreMapping.Column> refColumns = mapping.RefColumns.ToList();
foreach(var row in result.Rows) {
    var key = row.Values[keyColumnIndex];

VB.NET

XAF-How-to-Implement-CRUD-Operations-for-Non-Persistent-Objects-Stored-Remotely/VB/NonPersistentObjectsDemo.Module/DataStoreMapper.vb#L65

Dim refColumns As List(Of DataStoreMapping.Column) = mapping.RefColumns.ToList()
For Each row In result.Rows
    Dim key = row.Values(keyColumnIndex)