• Material 3
  • Material 3 Dark
  • Fluent
  • Fluent Dark
  • Bootstrap v5
  • Bootstrap v5 Dark
  • Tailwind CSS
  • Tailwind CSS Dark
  • Material
  • Bootstrap v4
  • High Contrast
Mode Selection
Theme Selection
*Translated by Google Translator.
Essential Studio
All Controls

Example of Editing in ASP.NET Core Pivot Table Control

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.


In the 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 for normal and batch edits:

  • 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 selected a row.
  • Update,Cancel - You can save or discard changes by clicking Update or Cancel in the toolbar, respectively.

This CRUD operations can be configured in a pivot table using editSettings 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.