LightSwitch HTML Edition
BeginUpdate Method
Example 






Suspend automatic updates to the output table while defining the Olap view.
Syntax
'Declaration
 
Public Sub BeginUpdate() 
'Usage
 
Dim instance As C1OlapEngine
 
instance.BeginUpdate()
public void BeginUpdate()
public procedure BeginUpdate(); 
public function BeginUpdate();
public: void BeginUpdate(); 
public:
void BeginUpdate(); 
Remarks
The C1OlapEngine updates the output table whenever the fields that make up the Olap view change. Before making multiple changes (such as defining a new Olap view), you can increase performance by enclosing the changes between calls to BeginUpdate and EndUpdate.
Example
The code below shows how to define a new Olap view efficiently by enclosing the changes between calls to BeginUpdate and EndUpdate.
// set data source (populates Fields list)
olap.DataSource = GetDataTable();
            
// prevent updates while building Olap view
olap.BeginUpdate();
            
// show countries in rows
olap.RowFields.Add("Country");
            
// show categories and products in columns
olap.ColumnFields.Add("Category");
olap.ColumnFields.Add("Product");
            
// show total sales in cells
olap.ValueFields.Add("Sales");
            
// done defining the view
olap.EndUpdate();
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

C1OlapEngine Class
C1OlapEngine Members

Send Feedback