Overview

A WinUI datagrid is a user interface control for displaying, editing, and analyzing large data sets. FlexGrid is a WPF datagrid optimized for high-performance and flexibility, enabling .NET developers to customize every aspect of the control.

  • Manage Data in Your WinUI Desktop Apps

    FlexGrid is a WinUI datagrid control perfect for displaying, creating, and editing bound or unbound data. It supports WinUI in desktop apps.

  • Deliver Familiar Spreadsheet Features With Minimal Code

    Modeled after Microsoft Excel, FlexGrid offers many features, including filtering, freezing, easy enabling, and familiarity.

  • High-Performance Solutions for Working With Large Data Sets

    FlexGrid is designed to aid large data sets with features like grouping, aggregation, and on-demand virtual mode.

Grouping and Aggregation

  • Enable runtime data grouping to help analyze large data sets
  • Display grouped data with a customizable group header and aggregated values
  • Grouping in FlexGrid is supported through the C1DataCollection component

Grouping and Aggregation
Built-In WinUI Datagrid Filtering

Built-In WinUI Datagrid Filtering

  • Provide searching functionality and filtering solutions to help users narrow down data sets
  • Enable full-text filtering with a textbox and get instant filtering that matches the exact case, partial text, or whole words across all columns
  • Display a filter row at the top of the WinUI datagrid to allow filtering on multiple columns

Multi-Column Sorting

  • Quickly sort columns at runtime by clicking or tapping the column headers
  • FlexGrid supports multi-column sorting by holding the CTRL-key
  • Customize the sort icon to match your application's style

Multi-Column Sorting
Cell Selection and Mouse Hover Styles

Cell Selection and Mouse Hover Styles

  • FlexGrid supports several selection modes, including cell, cell range, row, and row range selection
  • Provide drill-down or additional analysis on user selections
  • Enable checkbox selection and a customizable mouse-over style

WinUI Datagrid Editing

  • Inline editing makes it easy to modify any cell by double-clicking quickly
  • Provide a full pop-up edit form (See sample)
  • Users can easily add new rows. The placeholder row can be at the top or bottom

WinUI Datagrid Editing
Adaptive Column Sizing

Adaptive Column Sizing

  • Get adaptive or responsive column sizes with intuitive star-sizing techniques
  • Allow FlexGrid to automatically adjust column widths to fill available space, even as the user dynamically resizes the window

Data Bound or Unbound WinUI Datagrid

  • Supports flexible data binding with full support for common .NET binding scenarios
  • Automatically generate columns when bound or define them manually
  • Create a complete grid directly from code and fill it programmatically with unbound support
  • Create custom columns with images, numeric input, date, time, or whatever your application needs
  • Live updates to the underlying data can animate at runtime

Data Bound or Unbound WinUI Datagrid
On-Demand Loading and Data Virtualization

On-Demand Loading and Data Virtualization

  • Load data on-demand and improve large dataset performance by only retrieving the data the user can see with Virtual Mode
  • The C1DataCollection component supports FlexGrid data virtualization

Drill-Down Row Details

  • Collapsible row details provide an alternative approach to displaying additional or hierarchical information about a data row
  • Load row details on-demand–reducing the amount of data needed to render the initial WinUI datagrid

Drill-Down Row Details
WinUI Datagrid Paging

WinUI Datagrid Paging

  • Navigate through large data sets smoothly with paging
  • Display large data sets to the user in chunks or pages
  • Set page length and scroll forward or backward to various pages

Customized Appearance

  • Provide a custom skin or theme for the WinUI datagrid by simply setting properties–no need to modify the complex XAML template
  • Easily apply a light or dark theme to the datagrid
  • Quickly change brushes for selection, mouse-over, column headers, row headers, and alternating rows

Customized Appearance
Additional WinUI Datagrid Features

Additional WinUI Datagrid Features

  • Freezing: Freeze rows and columns so they remain static and visible as users scrolls
  • Merging: Merge across rows and down columns
  • Conditional Formatting: Use CellFactory to create custom cells to meet any criteria
  • Exporting: Save your grid to common formats, including CSV, text, and HTML