# C1.PivotEngine.C1PivotEngine.BeginUpdate ## Content

BeginUpdate Method

BeginUpdate()

Suspend automatic updates to the output table while defining the PivotEngine view.

Declaration

public void BeginUpdate()

Public Sub BeginUpdate()

Remarks

The C1.PivotEngine.PivotEngine updates the output table whenever the fields that make up the PivotEngine view change. Before making multiple changes (such as defining a new PivotEngine view), you can increase performance by enclosing the changes between calls to BeginUpdate() and EndUpdate().

Examples

The code below shows how to define a new PivotEngine view efficiently by enclosing the changes between calls to BeginUpdate() and EndUpdate().

// set data source (populates Fields list)
fp.DataSource = GetDataTable();

// prevent updates while building PivotEngine view
fp.BeginUpdate();

// show countries in rows
fp.RowFields.Add("Country");

// show categories and products in columns
fp.ColumnFields.Add("Category");
fp.ColumnFields.Add("Product");

// show total sales in cells
fp.ValueFields.Add("Sales");

// done defining the view
fp.EndUpdate();