The ASP.NET MVC Data Grid or Data Table, is a feature-rich control for displaying data in a tabular format. Its wide range of functionalities includes data binding, editing, Excel-like filtering, grouping, row reordering, freezing rows and columns, exporting to Excel, CSV and PDF formats, aggregating rows and more
Data Grid 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.
Data Grid 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 Data Grid help produce the best user experience. All Data Grid features work on touch devices with zero configuration.
Data Grid 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 Data Grid pager acts intelligently and changes its complete UI responsively based on the Data Grid 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 Data Grid, which meet a given filtering criteria. It supports various filter types that include powerful Excel-like filter. The Data Grid 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 Data Grid.
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 Data Grid 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 Data Grid regardless of the number of pages it has. It also has an option to print the currently viewed page alone.
Data Grid ensures that every cell is accessible using the keyboard. Major features like sort, select, and edit can be performed using keyboard commands alone; no mouse interaction is required. This helps in creating highly accessible applications using this component.
Data Grid view has complete WAI-ARIA accessibility support. The Data Grid 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.
Data Grid enables users from different locales to use it by formatting the date, currency, and numbering to suit locale preferences. It uses the internalization (i18n) library to handle value formatting.
Right-to-left rendering allows displaying the text and layout of the Data Grid 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 Data Grid 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 Data Grid size by setting the width and height properties. Horizontal and vertical scrollbars will appear when the content overflows the Data Grid element. For the Data Grid 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 Data Grid. 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.
Data Grid 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 Data Grid. 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 Data Grid 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.
Through paging, a segment of data can be viewed from the assigned data source. The ASP.NET MVC Data Grid offers built-in pager UI with options to customize its entire UI. It also has an on-demand paging mode for effective data retrieval from remote web services.
The ASP.NET MVC Data Grid works well with all modern web browsers such as Chrome, Firefox, Edge, Safari, and IE11. It supports IE11 with the help of polyfills.
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.