Skip to main content
All docs
V25.1
  • DxPivotTable.BeginUpdate() Method

    Suspends Pivot Table updates caused by parameter changes and method calls until the EndUpdate() method is called.

    Namespace: DevExpress.Blazor.PivotTable

    Assembly: DevExpress.Blazor.PivotTable.v25.1.dll

    NuGet Package: DevExpress.Blazor.PivotTable

    Declaration

    public void BeginUpdate()

    Remarks

    You can use BeginUpdate() and EndUpdate() methods to change values of the component parameters outside the component markup.

    The following code changes the sort order of the Region field in the BeginUpdate/EndUpdate code block:

    @rendermode InteractiveServer
    
    <DxButton Click="ChangeRegionSortOrder">Change Region Sort Order</DxButton>
    <p/>
    
    <DxPivotTable Data="SalesData"
             @ref="PivotTable">
        <Fields>
            <DxPivotTableField Field="@nameof(Sales.SaleInfo.Region)"
                               Area="@PivotTableArea.Row"
                               AreaIndex="0">
            </DxPivotTableField>
            <DxPivotTableField Field="@nameof(Sales.SaleInfo.Country)"
                               Area="@PivotTableArea.Row"
                               SortOrder="@PivotTableSortOrder.Descending"
                               AreaIndex="1" />
            <DxPivotTableField Field="@nameof(Sales.SaleInfo.Date)"
                               GroupInterval="@PivotTableGroupInterval.DateYear"
                               Area="@PivotTableArea.Column"
                               AreaIndex="0" 
                               Caption="Year" />
            <DxPivotTableField Field="@nameof(Sales.SaleInfo.Date)"
                               GroupInterval="@PivotTableGroupInterval.DateQuarter"
                               Area="@PivotTableArea.Column"
                               AreaIndex="1"
                               Caption="Quarter" />
            <DxPivotTableField Field="@nameof(Sales.SaleInfo.Amount)"
                               SortOrder="@PivotTableSortOrder.Ascending"
                               Area="@PivotTableArea.Data"
                               SummaryType="@PivotTableSummaryType.Sum"/>
        </Fields>
    </DxPivotTable>
    
    @code {
        IPivot PivotTable { get; set; }
        IEnumerable<SaleInfo> SalesData;
        protected override async Task OnInitializedAsync() {
            SalesData = await Sales.GetSalesAsync();
        }
    
        void ChangeRegionSortOrder() {
            PivotTable.BeginUpdate();
    
            PivotTable
                .GetFields()
                .First(f => f.Field == "Region")
                .ChangeSortOrder();
    
            PivotTable.EndUpdate();
        }
    }
    

    Implements

    See Also