SqlDataSource.Result Property

Gets a collection of tables and their relations from the current SqlDataSource.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v19.2.dll

Declaration

C#

[Browsable(false)]
public IResultSet Result { get; }

VB.NET

<Browsable(False)>
Public ReadOnly Property Result As IResultSet

Property Value

Type	Description
IResultSet	An object implementing the IResultSet interface that is the collection of tables and their relations from the current SqlDataSource.

Remarks

The Result property provides access to the collection of data tables and their relations from the current SqlDataSource. For each table, you can access columns and rows belonging to this table.

Note that for the inherited DashboardSqlDataSource class, the Result property does not return any data. The Dashboard control reads data internally.

Note

Note that the Result property is initialized after the SqlDataSource is filled (for instance, using the SqlDataSource.Fill method).

Example

The following example illustrates how to use the SqlDataSource.Result property to extract all data records from an SqlDataSource and pass them to a corresponding DataTable object.

C#

using DevExpress.DataAccess.Sql;
using DevExpress.DataAccess.Sql.DataApi;
using System;
using System.Data;
using System.Linq;
using System.Windows.Forms;
// ...

private void button1_Click(object sender, EventArgs e) {
    XtraReport1 report = new XtraReport1();
    SqlDataSource ds = report.DataSource as SqlDataSource;

    ITable src = ds.Result["Categories"];
    DataTable dest = new DataTable("Categories");
    foreach (IColumn column in src.Columns)
        dest.Columns.Add(column.Name, column.Type);
    foreach (IRow row in src)
        dest.Rows.Add(row.ToArray());
}

VB.NET

Imports DevExpress.DataAccess.Sql
Imports DevExpress.DataAccess.Sql.DataApi
Imports System.Data
Imports System.Linq
Imports System.Windows.Forms
' ...

Private Sub button1_Click(sender As Object, e As EventArgs)
    Dim report As New XtraReport1()
    Dim ds As SqlDataSource = TryCast(report.DataSource, SqlDataSource)

    Dim src As ITable = ds.Result("Categories")
    Dim dest As New DataTable("Categories")
    For Each column As IColumn In src.Columns
        dest.Columns.Add(column.Name, column.Type)
    Next
    For Each row As IRow In src
        dest.Rows.Add(row.ToArray())
    Next
End Sub

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Result property.

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;

Reporting_how-to-show-the-checkedcomboboxedit-editor-in-the-parameters-dialog-e1404/CS/WindowsApplication1/XtraReport1.cs#L20

parameterDataSource.Fill();
IResultSet result = parameterDataSource.Result;
ITable categoriesTable = result["Categories"];

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

Reporting_how-to-show-the-checkedcomboboxedit-editor-in-the-parameters-dialog-e1404/VB/WindowsApplication1/XtraReport1.vb#L18

parameterDataSource.Fill()
Dim result As IResultSet = parameterDataSource.Result
Dim categoriesTable As ITable = result("Categories")