XRTableRowCollection.Add(XRTableRow) Method

Appends the specified table row to the current collection.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v19.1.dll

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

Declaration

C#

public int Add(
    XRTableRow row
)

VB.NET

Public Function Add(
    row As XRTableRow
) As Integer

Parameters

Name	Type	Description
row	XRTableRow	An XRTableRow object to append to the collection.

Returns

Type	Description
Int32	An integer value indicating the position into which a new element was inserted.

Remarks

This method adds the object to the end of the collection.

Note

If you’re creating an XRTable object at runtime and manually add XRTableRow and XRTableCell objects to it, it is always required to enclose this code inside the XRTable.BeginInit and XRTable.EndInit method calls. Also, the final size of the table doesn’t consider the size of table rows and table cells being added to it. So, you need to manually set the table size and width before calling the XRTable.EndInit method.

Example

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

Tip

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

C#

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]"));

VB.NET

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]"))

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Add(XRTableRow) method.

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#

winforms-create-a-custom-exporter-for-pivotgridcontrol-with-xtrareport/CS/Report_at_Runtime/PivotReportGenerator.cs#L217

XRTableRow headerRow = new XRTableRow();
header.Rows.Add(headerRow);
XRTableRow detailRow = new XRTableRow();

how-to-create-a-custom-exporter-that-supports-autorowheight-bestfit-and-fittopage-t274241/CS/WpfApplication31/PivotReportGenerator.cs#L204

XRTableRow headerRow = new XRTableRow();
header.Rows.Add(headerRow);
XRTableRow detailRow = new XRTableRow();

reporting-create-table-at-runtime/CS/XtraReport1.cs#L35

    }
    table.Rows.Add(row);
}

Reporting_how-to-create-a-label-in-the-pageheader-band-when-a-field-is-dragged-from-the-t457241/CS/T457241/Form1.cs#L82

table.BeginInit();
table.Rows.Add(headerTableRow);
foreach(XRTableCell cell in sourceRow.Cells)

VB.NET

winforms-create-a-custom-exporter-for-pivotgridcontrol-with-xtrareport/VB/Report_at_Runtime/PivotReportGenerator.vb#L209

Dim headerRow As XRTableRow = New XRTableRow()
header.Rows.Add(headerRow)
Dim detailRow As XRTableRow = New XRTableRow()

how-to-create-a-custom-exporter-that-supports-autorowheight-bestfit-and-fittopage-t274241/VB/WpfApplication31/PivotReportGenerator.vb#L214

Dim headerRow As New XRTableRow()
header.Rows.Add(headerRow)
Dim detailRow As New XRTableRow()

reporting-winforms-create-simple-table/VB/XtraReport1.vb#L36

row.Cells.Add(cell1)
table.Rows.Add(row)
' Finish table initialization.

reporting-create-table-at-runtime/VB/XtraReport1.vb#L36

    table.Rows.Add(row)
Next

Reporting_how-to-create-a-label-in-the-pageheader-band-when-a-field-is-dragged-from-the-t457241/VB/T457241/Form1.vb#L90

table.BeginInit()
table.Rows.Add(headerTableRow)
For Each cell As XRTableCell In sourceRow.Cells