DataGrid has optimized design for high-performance. Loads high volume of data, nearly 1 million+ records, within one second without any performance degradation with the help of row and column virtualization.
Bind data seamlessly with various local and remote data sources such as JSON, RESTful services, OData services, and WCF services. It uses the data manager to handle data and supports customizing data requests and processing.
DataGrid has a highly responsive layout and an optimized design for desktops, touch screens, and smart phones. It works well on all mobile phones that use iOS, Android, or Windows 8 OS.
User-friendly touch gestures and an interactive UI design on DataGrid help produce the best user experience. All DataGrid features work on touch devices with zero configuration.
DataGrid is a mobile-first approach control. Its responsive user interface adapts automatically to any device and provides the best user experience to interact with the control. In addition, it has an option to hide specific columns for particular screen sizes using column-based media query support.
The DataGrid pager acts intelligently and changes its complete UI responsively based on the DataGrid dimension. Its optimized design provides the best UI interaction in different devices.
Aggregates for column values can be easily displayed using the aggregate feature. Aggregates can be customized to show their value in individual summary rows, individual group summary rows, or in group caption rows.
Filtering helps view particular or related records in the DataGrid, which meet a given filtering criteria. It supports various filter types that include powerful Excel-like filter. The DataGrid filter allows users to choose appropriate filter type, define their own custom filtering logic, and customize the filtering UI based on their application needs. It also has an option to filter diacritic characters in DataGrid.
Five built-in SASS-based themes are available such as: Material, Bootstrap, Bootstrap 4, Fabric, and High Contrast. Simplify theme customization either by overriding the existing SASS styling or creating custom themes by using the Theme Studio application.
Easily export the DataGrid control in various file formats such as Excel, PDF, or CSV. Users can also programmatically customize the exported document.
Allows users to print data either by using the print option from the toolbar or programmatically. Print all the rows of a DataGrid regardless of the number of pages it has. It also has an option to print the currently viewed page alone.
DataGrid view has complete WAI-ARIA accessibility support. The DataGrid UI includes high-contrast visual elements,helping visually impaired people to have the best viewing experience. Also, valid UI descriptions are easily accessible through assistive technologies such as screen readers.
Right-to-left rendering allows displaying the text and layout of the DataGrid from right to left. This improves the user experience and accessibility for RTL languages.
Based on their needs, users can allow localizing all the strings that are used in the user interface of the DataGrid control. It uses the localization (l10n) library to localize UI strings.
Row height is a major factor when displaying the number of records in the view port, and it is effortlessly customizable based on the application’s UI requirement. It is also possible to set row height conditionally.
The clipboard provides an option to copy selected rows or cells’ data into the clipboard. Use Ctrl+C and Ctrl+Shift+H key combinations to copy data with and without headers, respectively.
The context menu improves user action with Data Grid using popup menu. It appears when the cell, header, or pager is right clicked. In addition to built-in default menu items, it allows you to add custom context menu items.
Allows changing the DataGrid size by setting the width and height properties. Horizontal and vertical scrollbars will appear when the content overflows the DataGrid element. For the DataGrid to fill its parent container, the user has to simply set the height and width to 100%.
Using templates, users can create custom user experiences in the DataGrid. It provides various template options to create custom headers, custom cell contents, custom rows, detail rows, toolbars, and custom editors for edit action.
Stacked headers allow grouping and visualizing column headers in a stacked manner. There is no limit to the number of columns that can be stacked. Allows the user to perform all Data Grid actions, even when the columns are stacked.
DataGrid allows users to select rows or cells either by using checkbox or by simply clicking on them. Select more than one row or cell by holding Ctrl or Shift or Command, or programmatically.
Columns define the schema of data source in the DataGrid. It supports formatting, auto generating columns, column definitions, freezing rows and columns, column spanning, text wrapping, column chooser, column menu, and other important features.
Supports row grouping to display data in an organized way. Data can be grouped in the ascending or descending order. Rows can be grouped by dragging and dropping the desired columns in the interactive drop area.
The DataGrid allows users to sort rows either in the ascending or descending order against a column by simply clicking on the header. Sort multiple columns’ data by holding Ctrl key + header click. In addition, it allows users to define their own custom sorting logic based on their application needs.
Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.