Devextreme Datagrid Batch Editing

[Desmond Hutchins]

Ihave a datagrid configured with Batch Edit mode. When I send some request to my server, it replies with computed new values that I'd like to apply to my datagrid with Batch Edit mode features (green border around the cell, "Save changes" button enabled). I managed to make it work by browsing the grid and updating the cells with gridInstance.cellValue(...) to get the desired behavior. Right now it works well on short samples of data that fits on one single page, but I have issues when the sample is big enough to require multiple pages (only 10 items are displayed on each page). I thought about going through each page of the grid to browse its rows, but it seems a bit dirty to me and I'm concerned about the performances.

A nicer way would be to browse through the datasource instead of the datagrid and add some flag to the rows that need to be updated, and then refresh/repaint the datagrid. How can I achieve this? Or if we can't use flags or something similar, what is the proper way to update the whole grid no matter the number of pages?

This behavior is a known limitation of our components. The cellValue method is designed to modify visible rows only. We are going to update our documentation to make it clearer. As a possible approach, you can update rows via a data source layer using the update method. Meanwhile, since you use the batch edit mode, I wish to note that when the update method is used, rows will be changed without the ability to undo modifications. We are going to research if we can improve DataGrid functionality for this scenario in further versions.

The ASP.NET MVC GridView extension allows you to modify a batch of grid data on the client side and send it to the server in a single request. This topic describes how to enable batch data editing operations within your GridView. It also provides an overview of batch edit, together with a description of its limitations.

In batch edit mode, grid data contained in a page can be edited using in-line editors. All user changes are maintained on the client side until either the Save changes button is clicked or all changes are canceled by clicking the Cancel changes button.

The GridViewBatchEditSettings.EditMode property (using GridViewSettings.SettingsEditing.BatchEditSettings.EditMode) allows you to specify which control element (data cell or data row) is used to edit data.

Add a controller action method that will implement the following data record operations: add new records, save updated records and delete existing records within a data source.

Navigate to the Partial View that contains GridView code. In the grid settings, define the callback route value to the action method (see previous step) that will handle grid callbacks for batch data modification. Set the ASPxGridViewEditingSettings.Mode property to Batch.

Use the DevExpressEditorsBinder class to get valid editor values in the MVCxGridViewEditingSettings.BatchUpdateRouteValues method. Refer to the Binding Data Editors to Data topic for more information.

The BinaryImage control does not have any built-in functionality that would allow you to determine if the editor is focused (the ASPxClientEdit.GotFocus and ASPxClientEdit.LostFocus client events do not work). This imposes the following limitations on using BinaryImage in batch edit mode.

The ValidationSettings.SetFocusOnError property has no effect because errors are handled at the row/cell level. Use the GridBatchEditSettings.AllowEndEditOnValidationError property to keep the editor focused until an end-user inputs the correct value. For more information on validating grid data in batch edit mode, refer to the following topic: Validation in batch edit mode.

Our WinForms Chart Control now supports nested Series Templates - allowing you to implement drill-down enabled charts with ease. You can create endless drill-down levels and use the control's integrated Breadcrumb navigation option to move across your data hierarchy.

Our WinForms and WPF Chart controls now support keyboard navigation. New settings allow you to configure hotkeys. Hotkeys can also be used to affect the behavior of mouse buttons when zooming in/out or zooming to a rectangle.

The Chart Control's Crosshair Cursor can now display Technical Indicators. We've also extended the Indicator's API and made it similar to the Series API. All settings available for a series are now available for an indicator.

Excel-inspired group filters were first introduced in May 2018 for our WinForms Pivot Grid and TreeList controls. With this update, we've added this capability to our WinForms Grid control. Filter dropdowns can now group filter items from two or more columns, and present results as a hierarchical checked list.

You can now pan and zoom by using the Diagram Control's Pan and Zoom window. The blue box indicates the region of the page that is shown in the drawing window. Resize the blue box by dragging a side until it fits the area that you wish to magnify. To pan the diagram, drag the blue box over the section you want to view.

When the DevExpress Diagram Control calculates routes for RightAngle connectors, it tries to find the closest route from start to finish. This can result in overlaps when multiple connectors originate from the same point. Many of you have asked us to deliver an alternative solution to help reduce confusion.

We have extended our CheckEdit check styles. New SVG check styles are more attractive and support all the benefits that come with the use of vector-based icons (scaling without quality loss, automatic color adaptation based on the current skin and palette).

The DevExpress WinForms Accordion control extends the capabilities found in our NavBar control. If you are still using the NavBar control and want to replace it with our Accordion while preserving customization settings and paint styles, click the 'Convert to AccordionControl' smart tag. Note that event handlers are not converted. You will need to handle all item interaction events manually.

You can assign an OLAP Multidimensional Expression (MDX) to a PivotGrid field and create an Unbound Field for OLAP. You can also use the OLAPQueryData event to obtain an MDX query (used by the pivot grid to request data).

With this release, we've replicated the look and feel of the latest version of Microsoft Office. Our Office 2019 Style includes new tab styles, animation effects, and the ability to minimize the Ribbon to a single-row tabbed toolbar.

Our WinForms Scheduler can now automatically synchronize appointments with Google Calendar. Data can be synced in both directions, which means that all changes made in your WinForms application will be automatically reflected in Google Calendar.

As you know, when an application includes multiple forms with a large number of controls, changing icons (replacing raster graphics with vector images) may be quite time consuming. Our new Image Picker makes this process much easier. It allows you to drag-and-drop icons onto controls. Integrated smart search allows you to quickly locate the desired icon.

You no longer need to hunt for a perfect hue to match an existing application theme when you set a custom background/foreground color for UI elements. Skin Colors remain consistent with the currently applied application theme.

If you need to display a grayed-out icon when a button is disabled, and a highlighted icon when the button is pressed, specify SVG for the Normal state only. Our graphics engine will automatically re-paint it when required.

In our last release, we introduced DirectX hardware acceleration support and boosted TreeList rendering on High DPI devices. In v18.2, we've improved our rendering engine and made the control significantly faster. Enhancements have been made to common usage scenarios including like repainting, batch updates, the processing of large amounts of data, etc.

The DevExpress WinForms TreeList allows you to bind to hierarchical data sources (for example, a list of lists). It will automatically traverse through the entire hierarchy and build the corresponding tree layout.

Excel-inspired group filters were first introduced in May 2018 for both our WinForms Pivot Grid and TreeList controls. With this update, we've extended this feature to our WinForms Vertical Grid control. Filter dropdowns can now group filter items from two or more data fields, and display results as a hierarchical checked list.

In our last release, we gave you the ability to create Windows 10-inspired toast notifications using XML. You could add app logo, hero image, attribution text, custom Timestamp, buttons, etc. With this update, you can handle user inputs (text and selection), respond to button clicks as well as persist your application toast notifications in Action Center.

Our scrollbars now support Microsoft's Fluent UI. When used, a scrollbar is collapsed to a thin stripe when not active, and expands to a semi-transparent bar when a user hovers the mouse pointer over it.

We continue to improve our DirectX rendering engine and in so doing, we've improved performance and made HighDPI support a reality on the WinForms platform. The following performance benchmark results speak louder than words. In v18.2, scrolling performance is more than three times faster with DirectX enabled.

v18.2 introduces Filtering UI Blocks - separate controls allowing you to filter data in our Grid and TreeList controls. Simply connect a filter element to a supported control and specify the fields to filter against:

3a8082e126