Grids News

Add Data-Virtualized Paging to WinForms Datagrids

May 14, 2024
ComponentOne WinForms datagrid offers paging to optimize performance for large datasets with on-demand data loading.

ComponentOne Studio WinForms is a comprehensive development toolkit that empowers you to build feature-rich Windows Forms applications with ease. It equips you with over 120 UI controls spanning data presentation, input elements, and application layout. ComponentOne boasts extensive customization options, seamless Visual Studio integration, and support for the latest .NET versions, making it a valuable asset for streamlining WinForms development.

In this blog post, MESCIUS Software Engineer Kartik Dua demonstrates how paging can be implemented in the FlexGrid Datagrid control to provide an intuitive way to interact with large sets of data. Steps include:

  • Setup a WinForms App with the Required Packages
  • Create a Virtual DataCollection
  • Create a Paged DataColleciton and Bind to FlexGrid
  • Handle the Toolstrip Event to Perform Navigation

A demo project to implement the paging functionality is available for download, as well.

Read the full blog to get started working with large datasets quickly and efficiently.

ComponentOne Studio WinForms is licensed per Developer on a perpetual basis and includes a 12 month subscription. Priority Support is also available. See our ComponentOne Studio WinForms licensing page for full details.

ComponentOne FlexGrid for WinForms is available to buy in the following products:

Enhance Data Comprehension with Sparklines

May 13, 2024
Smart HTML Elements v19 adds sparkline support to help users quickly understand patterns in their data without the need for separate charts.

Smart HTML Elements is an enterprise-grade UI library offering pre-built web components for developers in Angular, React, Vue, Blazor, and JavaScript. It boasts over 60 ready-to-use components like grids, charts, schedulers, and editors, all featuring two-way data binding, responsiveness, accessibility, and theming capabilities. This library helps developers rapidly build dynamic and modern web applications with consistent look-and-feel and rich functionalities, accelerating development time and ensuring professional quality.

The Smart HTML Elements v19.0.0 release adds support for Grid Sparklines. These are small, data-intense, design simple charts that fit into a single cell of a grid and provide a visual representation of data trends. They are typically used to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Grid Sparklines help users to quickly understand patterns and trends in their data without having to create separate charts or graphs.

To see a full list of what's new in v19.0.0, see our release notes.

Smart HTML Elements is licensed per developer and is available as a Perpetual license with 1 year support and maintenance. It includes distribution to Unlimited Web applications, SaaS projects, Intranets and Websites. See our Smart HTML Elements licensing page for full details.

Learn more on our Smart HTML Elements product page.

Export Grid Data to CSV for Analysis and Processing

May 1, 2024
Efficiently transform your tabular data into actionable insights with a grid control that offers seamless CSV export functionality.

CSV export in grid components refers to the functionality that allows users to download data as a Comma-Separated Values (CSV) file. Exporting data to CSV format offers significant benefits, including compatibility with a wide range of applications, such as Microsoft Excel, Google Sheets, and other data analysis tools, facilitating easy sharing and processing. Use cases for CSV export are diverse, ranging from business analysts exporting reports for further analysis, to IT professionals extracting system data for audit and compliance purposes. Developers can leverage CSV export to provide users with a straightforward method to back up or transfer data between different systems or platforms, enhancing the utility and flexibility of applications that handle large datasets.

Several WPF grid controls offer export to CSV including:

  • DevExpress WPF Data Grid (part of DevExpress WPF) facilitates exporting data to CSV format directly from the grid component.
  • FlexGrid for WPF (part of ComponentOne Studio WPF by MESCIUS) empowers developers to easily export grid content to CSV files with customizable formatting options.
  • Telerik UI for WPF GridView (part of Telerik UI for WPF) enables seamless CSV export of grid data, integrating with various data binding scenarios.
  • Xceed DataGrid for WPF offers effortless CSV export functionality for WPF datagrids, ensuring data integrity during export.

For an in-depth analysis of features and price, visit our WPF Grid controls comparison.

Compare WPF Grid Controls

Navigate Seamlessly Between Cells Within Selections

April 26, 2024
Handsontable 14.3 allows experienced grid users to quickly move between specific cells within a selection using keyboard shortcuts.

Handsontable is a JavaScript library designed to help developers build interactive data grids into their web applications. Offering a familiar spreadsheet-like interface, it allows users to edit, sort, and filter data with ease. Highly customizable and compatible with popular frameworks like React and Angular, Handsontable empowers developers to build robust data manipulation features into their web applications.

Handsontable 14.3 adds a new feature to streamline navigation within pre-selected cells. Power users and those accustomed to Tab navigation can now leverage arrow keys or the mouse for selection, then efficiently move between the chosen cells using Tab/Shift+Tab for horizontal movement and Enter/Shift+Enter for vertical movement. Editing remains intuitive, as typing any character initiates editing even within dropdown or date cells.

To see a full list of what's new in version 14.3.0, see our release notes.

Handsontable is licensed per developer and is available as an Annual or Perpetual license with 1 year support and maintenance. See our Handsontable licensing page for full details.

For more information, visit our Handsontable product page.

Reduce Visual Clutter in Your Grids

April 24, 2024
Hiding columns allows users to customize their grid view by temporarily removing irrelevant data for more efficient analysis.

Hiding columns in a grid allows for a more focused data display by selectively removing irrelevant or less important information from the user's view. This functionality improves data clarity, particularly for grids with a large number of columns. By hiding specific columns, users can concentrate on the most important data points, reducing clutter and improving overall user experience.

Several jQuery Grid controls offer the ability to hide columns including:

  • DevExtreme HTML5 JavaScript Data Grid (part of DevExtreme Complete by DevExpress) empowers users to selectively hide columns for a focused data view.
  • Kendo UI for jQuery Grid (part of Kendo UI by Telerik) enables column hiding to prioritize relevant information and minimize clutter.
  • Syncfusion Grid control for JavaScript (part of Syncfusion Essential Studio Enterprise) facilitates hiding columns to enhance clarity and user experience with large datasets.
  • Ignite UI jQuery Grid (part of Infragistics Ignite UI) allows you to customize the grid by hiding columns for a streamlined data presentation.

For an in-depth analysis of features and price, visit our jQuery Grid controls comparison.

Compare jQuery Grid Controls