• Material
  • Fabric
  • Bootstrap
  • Bootstrap v4
  • High Contrast
Preferences
Theme Selection
Mode Selection
Touch
Mouse
Essential JS 2
HOME
All Controls

Button

This sample demonstrates CRUD operations performed in the raw items of any value cell in a pivot grid.

DEMO
SOURCE

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 grid 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 grid with icons to perform CRUD operations. Editing using cell double-click is restricted here.