JavaScript/jQuery DataGrid API

Specifies the shortcut key that sets focus on the widget.

Specifies whether or not the widget changes its state when interacting with a user.

Specifies whether a user can reorder columns.

Specifies whether a user can resize columns.

Specifies whether data should be cached.

Enables a hint that appears when a user hovers the mouse pointer over a cell with truncated content.

Specifies whether columns should adjust their widths to the content.

Configures the column chooser.

Configures column fixing.

Specifies whether the widget should hide columns to adapt to the screen or container size. Ignored if allowColumnResizing is true and columnResizingMode is "widget".

Specifies the minimum width of columns.

Specifies how the widget resizes columns. Applies only if allowColumnResizing is true.

An array of grid columns.

Specifies the width for all data columns. Has a lower priority than the column.width option.

Customizes columns after they are created.

Customizes data before export. You can use the export.customizeExcelCell function instead.

Binds the widget to data.

Specifies the format in which date-time values should be sent to the server. Use it only if you do not specify the dataSource at design time.

Specifies whether the widget responds to user interaction.

Configures editing.

Specifies the attributes to be attached to the widget's root element.

Indicates whether to show the error row.

Configures client-side exporting.

Configures the integrated filter builder.

Configures the popup in which the integrated filter builder is shown.

Configures the filter panel.

Configures the filter row.

Specifies whether to synchronize the filter row, header filter, and filter builder. The synchronized filter expression is stored in the filterValue option.

Specifies a filter expression.

Specifies the index of the column focused initially or currently in the data row area.

Specifies whether the focused row feature is enabled.

Specifies the initially or currently focused grid row's index. Use it when focusedRowEnabled is true.

Specifies initially or currently focused grid row's key. Use it when focusedRowEnabled is true.

Specifies whether the widget can be focused using keyboard navigation.

Configures grouping.

Configures the group panel.

Configures the header filter feature.

Specifies the widget's height.

Specifies whether to highlight rows and cells with edited data. repaintChangesOnly should be true.

Specifies text for a hint that appears when a user pauses on the widget.

Specifies whether to highlight rows when a user moves the mouse pointer over them.

Configures keyboard navigation.

Specifies which data field provides keys for data items. Applies only if data is a simple array.

Configures the load panel.

Allows you to build a master-detail interface in the grid.

Specifies text shown when the widget does not display any data.

A function that is executed before an adaptive detail row is rendered.

A function that is executed when a cell is clicked or tapped. Executed before onRowClick.

A function that is executed when a cell is double-clicked or double-tapped. Executed before onRowDblClick.

A function that is executed after the pointer enters or leaves a cell.

A function that is executed after a cell is created.

A function that is executed when the widget's content is ready and each time the content is changed.

A function that is executed before the context menu is rendered.

A function that is executed when an error occurs in the data source.

A function that is executed before the widget is disposed of.

A function that is executed before a cell or row switches to the editing state.

A function that is executed after an editor is created. Not executed for cells with an editCellTemplate.

A function used to customize or replace default editors. Not executed for cells with an editCellTemplate.

A function that is executed after data is exported.

A function that is executed before data is exported.

A function that is executed before a file with exported data is saved to the user's local storage.

A function that is executed after the focused cell changes.

A function that is executed before the focused cell changes.

A function that is executed after the focused row changes. Applies only when focusedRowEnabled is true.

A function that is executed before the focused row changes. Applies only when focusedRowEnabled is true.

A function used in JavaScript frameworks to save the widget instance.

A function that is executed before a new row is added to the widget.

A function that is executed when the widget is in focus and a key has been pressed down.

A function that is executed after a widget option is changed.

A function that is executed when a row is clicked or tapped.

A function that is executed after a row is collapsed.

A function that is executed before a row is collapsed.

A function that is executed when a row is double-clicked or double-tapped. Executed after onCellDblClick.

A function that is executed after a row is expanded.

A function that is executed before a row is expanded.

A function that is executed after a new row has been inserted into the data source.

A function that is executed before a new row is inserted into the data source.

A function that is executed after a row is created.

A function that is executed after a row has been removed from the data source.

A function that is executed before a row is removed from the data source.

A function that is executed after a row has been updated in the data source.

A function that is executed before a row is updated in the data source.

A function that is executed after cells in a row are validated against validation rules.

A function that is executed after selecting a row or clearing its selection.

A function that is executed before the toolbar is created.

Configures the pager.

Configures paging.

Notifies the DataGrid of the server's data processing operations.

Specifies whether to render the filter row, command columns, and columns with showEditorAlways set to true after other elements.

Specifies whether to repaint only those cells whose data changed.

Specifies whether rows should be shaded differently.

An alias for the rowTemplate option specified in React. Accepts a custom component. Refer to Using a Custom Component for more information.

An alias for the rowTemplate option specified in React. Accepts a rendering function. Refer to Using a Rendering Function for more information.

Specifies a custom template for rows.

Switches the widget to a right-to-left representation.

Configures scrolling.

Configures the search panel.

Allows you to select rows or determine which rows are selected. Applies only if selection.deferred is false.

Configures runtime selection.

Specifies filters for the rows that must be selected initially. Applies only if selection.deferred is true.

Specifies whether the outer borders of the widget are visible.

Specifies whether column headers are visible.

Specifies whether vertical lines that separate one column from another are visible.

Specifies whether horizontal lines that separate one row from another are visible.

Allows you to sort groups according to the values of group summary items.

Configures runtime sorting.

Configures state storing.

Specifies the options of the grid summary.

Specifies the number of the element when the Tab key is used for navigating.

Specifies whether to enable two-way data binding.

Specifies whether the widget is visible.

Specifies the widget's width.

Specifies whether text that does not fit into a column should be wrapped.

Adds a new column.

Adds an empty data row.

Shows the load panel.

Prevents the widget from refreshing until the endUpdate() method is called.

Gets a data object with a specific key.

Discards changes that a user made to data.

Gets the value of a cell with a specific row index and a data field, column caption or name.

Sets a new value to a cell with a specific row index and a data field, column caption or name.

Gets the value of a cell with specific row and column indexes.

Sets a new value to a cell with specific row and column indexes.

Clears all filters applied to widget rows.

Clears all row filters of a specific type.

Ungroups grid records.

Clears selection of all rows on all pages.

Clears sorting settings of all columns at once.

Switches the cell being edited back to the normal state. Takes effect only if editing.mode is batch and showEditorAlways is false.

Collapses the currently expanded adaptive detail row (if there is one).

Collapses master rows or groups of a specific level.

Collapses a group or a master row with a specific key.

Gets the data column count. Includes visible and hidden columns, excludes command columns.

Gets all options of a column with a specific identifier.

Gets the value of a single column option.

Updates the value of a single column option.

Updates the values of several column options.

Specifies the device-dependent default configuration options for this component.

Removes a column.

Removes a row with a specific index.

Clears the selection of all rows on all pages or the currently rendered page only.

Cancels the selection of rows with specific keys.

Disposes of all the resources allocated to the DataGrid instance.

Switches a cell with a specific row index and a data field to the editing state. Takes effect only if the editing mode is "batch" or "cell".

Switches a cell with specific row and column indexes to the editing state. Takes effect only if the editing mode is "batch" or "cell".

Switches a row with a specific index to the editing state. Takes effect only if the editing mode is "row", "popup" or "form".

Gets the root widget element.

Hides the load panel.

Refreshes the widget after a call of the beginUpdate() method.

Expands an adaptive detail row.

Expands master rows or groups of a specific level. Does not apply if data is remote.

Expands a group or a master row with a specific key.

Exports grid data to Excel.

Gets a filter expression applied to the widget's data source using the filter(filterExpr) method and the DataSource's filter option.

Applies a filter to the widget's data source.

Sets focus on the widget.

Sets focus on a specific cell.

Gets a cell with a specific row index and a data field, column caption or name.

Gets a cell with specific row and column indexes.

Gets the total filter that combines all the filters applied.

Gets the total filter that combines all the filters applied.

Gets the DataSource instance.

Gets the instance of a widget found using its DOM node.

Gets the key of a row with a specific index.

Gets the container of a row with a specific index.

Gets the index of a row with a specific key.

Gets the instance of the widget's scrollable part.

Gets the currently selected rows' keys.

Gets the selected rows' data objects.

Gets the value of a total summary item.

Gets all visible columns.

Gets all visible columns at a specific hierarchical level of column headers. Use it to access banded columns.

Gets currently rendered rows.

Checks whether the widget has unsaved changes.

Hides the column chooser.

Gets the widget's instance. Use it to access other methods of the widget.

Checks whether an adaptive detail row is expanded or collapsed.

Checks whether a specific group or master row is expanded or collapsed.

Checks whether a row with a specific key is focused.

Checks whether a row found using its data object is selected. Takes effect only if selection.deferred is true.

Checks whether a row with a specific key is selected. Takes effect only if selection.deferred is false.

Gets a data object's key.

Navigates the grid to the data page that contains the row with the specified key and scrolls the grid to display the row if it is not in the viewport.

Detaches all event handlers from a single event.

Detaches a particular event handler from a single event.

Subscribes to an event.

Subscribes to events.

Gets all widget options.

Gets the value of a single option.

Updates the value of a single option.

Updates the values of several options.

Gets the total page count.

Gets the current page index.

Switches the widget to a specific page using a zero-based index.

Gets the current page size.

Sets the page size.

Reloads data and repaints the widget.

Reloads data and repaints the widget or elements whose data changed.

Repaints the widget without reloading data. Call it to update the widget's markup.

Repaints specific rows.

Saves changes that a user made to data.

Seeks a search string in the columns whose allowSearch option is true.

Selects all rows.

Selects rows with specific keys.

Selects rows with specific indexes.

Shows the column chooser.

Gets the current widget state.

Sets the widget state.

Gets the total row count.

Recovers a row deleted in batch editing mode.

Updates the widget's content after resizing.

Raised before an adaptive detail row is rendered.

Raised when a cell is clicked or tapped.

Raised when a cell is double-clicked or double-tapped.

Raised after the pointer enters or leaves a cell.

Raised after a cell is created.

Raised when the widget's content is ready.

Raised before the context menu is rendered.

Raised when an error occurs in the data source.

Raised before the widget is disposed of.

Raised before a cell or row switches to the editing state.

Raised after an editor is created.

Raised before an editor is created.

Raised after data is exported.

Raised before data is exported.

Raised before a file with exported data is saved to the user's local storage.

Raised after the focused cell changes.

Raised before the focused cell changes.

Raised after the focused row changes. Applies only when focusedRowEnabled is true.

Raised before the focused row changes. Applies only when focusedRowEnabled is true.

Raised only once, after the widget is initialized.

Raised before a new row is added to the widget.

Raised when the widget is in focus and a key has been pressed down.

Raised after a widget option is changed.

Raised when a row is clicked or tapped.

Raised after a row is collapsed.

Raised before a row is collapsed.

Raised when a row is double-clicked or double-tapped.

Raised after a row is expanded.

Raised before a row is expanded.

Raised after a new row has been inserted into the data source.

Raised before a new row is inserted into the data source.

Raised after a row is created.

Raised after a row has been removed from the data source.

Raised before a row is removed from the data source.

Raised after a row has been updated in the data source.

Raised before a row is updated in the data source.

Raised after cells in a row are validated against validation rules.

Raised after selecting a row or clearing its selection.

Raised before the toolbar is created.