IResultSet Interface

A cache of data retrieved using the SqlDataSource.

Namespace: DevExpress.DataAccess.Sql.DataApi

Assembly: DevExpress.DataAccess.v18.1.dll

Declaration

C#

public interface IResultSet :
    IEnumerable<ITable>,
    IEnumerable

VB.NET

Public Interface IResultSet
    Inherits IEnumerable(Of ITable),
             IEnumerable

Related API Members

The following members accept/return IResultSet objects:

• SqlDataSource.Result

Remarks

Use the SqlDataSource.Result property to access the collection of data tables and their relations from the current IResultSet. You can access the required table (an object implementing ITable) by its index or name. To obtain master-detail relations for the specified table, use the ITable.DetailRelations property.

For each table, you can access its columns using the ITable.Columns property. This property returns the object implementing the IColumn interface. To obtain the column name and type, use the IColumn.Name and IColumn.Type properties, respectively.

You can also access individual table rows (objects implementing IRow) using index notation.

Related GitHub Examples

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

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#

Reporting_sqldatasource-how-to-use-expressionevaluator-to-programmatically-filter-report-t328522/CS/XtraReport2.cs#L27

IResultSet resultSet = (this.DataSource as SqlDataSource).Result as DevExpress.DataAccess.Sql.DataApi.IResultSet;
ITable tableProd = null;

VB.NET

Reporting_sqldatasource-how-to-use-expressionevaluator-to-programmatically-filter-report-t328522/VB/XtraReport2.vb#L29

Dim resultSet As IResultSet = TryCast((TryCast(Me.DataSource, SqlDataSource)).Result, DevExpress.DataAccess.Sql.DataApi.IResultSet)
Dim tableProd As ITable = Nothing