XRTableRowCollection Class

A collection of XRTableRow objects.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v20.1.dll

NuGet Packages: DevExpress.Reporting.Core, DevExpress.WindowsDesktop.Reporting.Core

Declaration

C#
VB.NET

public class XRTableRowCollection :
    XRControlCollection,
    IEnumerable<IWeighty>,
    IEnumerable,
    IEnumerable<XRTableRow>

Public Class XRTableRowCollection
    Inherits XRControlCollection
    Implements IEnumerable(Of IWeighty),
               IEnumerable,
               IEnumerable(Of XRTableRow)

The following members return XRTableRowCollection objects:

Remarks

A collection of this class is used to hold the rows of a table. This collection is returned by the XRTable.Rows property of an XRTable object.

Example

The code sample below illustrates how to create an XRTable at runtime.

Tip

Online Example: Runtime table creation best practices (iterative approach)

C#
VB.NET

using DevExpress.XtraReports.UI;
// ...
private static SqlDataSource CreateSQLDataSource() {
    // Create a data source with the connection parameters.  
    Access97ConnectionParameters connectionParameters = new Access97ConnectionParameters("Data/nwind.mdb", "", "");
    SqlDataSource dataSource = new SqlDataSource(connectionParameters);

    // Create a SELECT query.
    SelectQuery query = SelectQueryFluentBuilder
        .AddTable("Products")
        .SelectColumn("ProductName")
        .SelectColumn("UnitPrice")
        .Build("selectQuery");

    // Add the query to the collection and return the data source. 
    dataSource.Queries.Add(query);
    dataSource.Fill();
    return dataSource;
}
// ...
// Create a new data source.
SqlDataSource sqlDataSource = CreateSQLDataSource();

// Create a new report and assign a data source to it.
XtraReport report = new XtraReport();
report.DataSource = ds;
report.DataMember = "queryProducts";

// Create a detail band and add it to the report.
DetailBand detailBand = new DetailBand();
report.Bands.Add(detailBand);

// Create a table and add it to the detail band.
XRTable table = new XRTable();
detailBand.Controls.Add(table);

// Create a row with the product name and product price cells.
XRTableRow row = new XRTableRow();
table.Rows.Add(row);
XRTableCell productName = new XRTableCell();
XRTableCell productPrice = new XRTableCell();
row.Cells.Add(productName);
row.Cells.Add(productPrice);

// Bind table cells to data fields.
productName.ExpressionBindings.Add(new ExpressionBinding("BeforePrint", "Text", "[ProductName]"));
productPrice.ExpressionBindings.Add(new ExpressionBinding("BeforePrint", "Text", "[UnitPrice]"));

Imports DevExpress.XtraReports.UI
' ...

' Create a new report and assign a data source to it.
Private report As New XtraReport()
report.DataSource = ds
report.DataMember = "queryProducts"

' Create a detail band and add it to the report.
Dim detailBand As New DetailBand()
report.Bands.Add(detailBand)

' Create a table and add it to the detail band.
Dim table As New XRTable()
detailBand.Controls.Add(table)

' Create a row with the product name and product price cells.
Dim row As New XRTableRow()
table.Rows.Add(row)
Dim productName As New XRTableCell()
Dim productPrice As New XRTableCell()
row.Cells.Add(productName)
row.Cells.Add(productPrice)

' Bind table cells to data fields.
productName.ExpressionBindings.Add(New ExpressionBinding("BeforePrint", "Text", "[ProductName]"))
productPrice.ExpressionBindings.Add(New ExpressionBinding("BeforePrint", "Text", "[UnitPrice]"))