IResultSet Interface

A cache of data retrieved using the SqlDataSource.

Namespace: DevExpress.DataAccess.Sql.DataApi

Assembly: DevExpress.DataAccess.v23.2.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

public interface IResultSet :
    IEnumerable<ITable>,
    IEnumerable

VB.NET

Public Interface IResultSet
    Inherits IEnumerable(Of ITable),
             IEnumerable

Related API Members

The following members 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.