IRow Interface

A row of data in a ITable.

Namespace: DevExpress.DataAccess.Sql.DataApi

Assembly: DevExpress.DataAccess.v18.1.dll

Declaration

C#

public interface IRow :
    IEnumerable<object>,
    IEnumerable

VB.NET

Public Interface IRow
    Inherits IEnumerable(Of Object),
             IEnumerable

Related API Members

The following members accept/return IRow objects:

• ITable.Item[Int32]

Remarks

Use index notation to access individual table rows (ITable.Item).

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 snippet (auto-collected from DevExpress Examples) contains a reference to the IRow 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_how-to-use-backstage-print-preview-control/CS/DocumentPrintPreview/ViewModel.cs#L10

public virtual EmployeeReport Report { get; protected set; }
public virtual IRow SelectedEmployee { get; set; }
public CustomSettingsViewModel CustomSettings { get; }

VB.NET

Reporting_how-to-use-backstage-print-preview-control/VB/DocumentPrintPreview/ViewModel.vb#L14

Public Overridable Property SelectedEmployee As IRow