corelibraries-devexpress-dot-xpo-dot-db-dot-selectstatementresult.md
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.v25.2.dll
NuGet Package : DevExpress.Data
public SelectStatementResultRow[] Rows
Public Rows As SelectStatementResultRow()
| Type |
|---|
| DevExpress.Xpo.DB.SelectStatementResultRow[] |
The following code snippets (auto-collected from DevExpress Examples) contain references 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.
void GetColumns(DBTable table) {
foreach(SelectStatementResultRow row in SelectData(new Query("select c.name, c.type, c.prec, c.length, c.usertype, @@ncharsize, c.status, dflt.name defaultValueName " +
"from syscolumns c " +
List<DataStoreMapping.Column> refColumns = mapping.RefColumns.ToList();
foreach(var row in result.Rows) {
var key = row.Values[keyColumnIndex];
Dim refColumns As List(Of DataStoreMapping.Column) = mapping.RefColumns.ToList()
For Each row In result.Rows
Dim key = row.Values(keyColumnIndex)
See Also