Blazor Pivot Table Example - Editing

Pivot Table / Miscellaneous / Editing

This sample demonstrates CRUD operations performed over the raw items of any value cell in a pivot table. Different types of cell editing options are provided to make editing simpler.

Loading Syncfusion Blazor Server Demos…

Properties

In this sample, the raw items of any value cell can be viewed in a drill-through dialog by double-clicking the cell. CRUD operations can be performed by double-clicking the cells or using toolbar options. The following CRUD operations can be performed through toolbar operations,

  • Add - To add new record, click Add in the toolbar.
  • Edit - To edit record, double click a cell.
  • Delete - To delete a record, click Delete in the toolbar after selecting a row.
  • Update,Cancel - You can save or discard changes by clicking Update or Cancel in the toolbar, respectively.

The above CRUD operations can be configured in a pivot table using PivotViewCellEditSettings in code behind. There are also different modes to manipulate the data source. The available modes are:

  • Normal - Editing by row.
  • Batch - Editing individual cells and bulk updating.
  • Dialog - Editing by row with a dialog option.
  • Command Columns - An additional column appends to the data grid with icons to perform CRUD operations. Editing using cell double-click is restricted here.

More information on the editing feature can be found in this documentation section.

Transform your Blazor web apps today with Syncfusion® Blazor components
100+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE