corelibraries-devexpress-dot-dataaccess-dot-sql-dot-dataapi-42033c5f.md
A row of data in a ITable.
Namespace : DevExpress.DataAccess.Sql.DataApi
Assembly : DevExpress.DataAccess.v25.2.dll
NuGet Package : DevExpress.DataAccess
public interface IRow :
IEnumerable<object>,
IEnumerable
Public Interface IRow
Inherits IEnumerable(Of Object),
IEnumerable
The following members return IRow objects:
Use index notation to access individual table rows (ITable.Item).
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.
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;
ds.Fill();
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());
}
Imports DevExpress.DataAccess.Sql
Imports DevExpress.DataAccess.Sql.DataApi
Imports System
Imports System.Data
Imports System.Linq
Imports System.Windows.Forms
' ...
Private Sub button1_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim report As New XtraReport1()
Dim ds As SqlDataSource = TryCast(report.DataSource, SqlDataSource)
ds.Fill()
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 column
For Each row As IRow In src
dest.Rows.Add(row.ToArray())
Next row
End Sub
See Also