WPF DataGrid initial column creation Virtualization

Question

I am trying to migrate from the xceed DataGrid to the standard DataGrid in the WPF controls. The issue that I am encountering and is blocking me is the Column Virtualization.

More specifically, the initial creation of the columns of the DataGrid. Since my data source is dynamic, the number of columns has to be created at runtime and for a large number of columns, the application freezes - this does not happen with the xceed DataGrid.

I have tried different data sources: ListCollectionView, CollectionViewSource, DataTable, but there is no difference.

This behavior of the DataGrid can be easily reproduced in a demo project. Creating 10k of columns will hang the UI for a few seconds, yet when you assign data to these columns it is instantaneous (as expected from the virtualization).

And without surprise, 10k of rows are created in an instant.

I have played with most of the options below

       VirtualizingPanel.IsVirtualizing="True"
       VirtualizingPanel.IsContainerVirtualizable="True"
       VirtualizingPanel.IsVirtualizingWhenGrouping="True"
       VirtualizingPanel.VirtualizationMode="Standard"
       EnableColumnVirtualization="True"
       EnableRowVirtualization="True"

yet I cannot make the column creation to be virtualized.

Any suggestions?

Demo code below: MainWindow.xaml

MainWindow.xaml.cs

namespace WpfApp1
{
    /// 
    /// Interaction logic for MainWindow.xaml
    /// 
    public partial class MainWindow : Window
    {
        DataTable myDataTableColumnWeighted;
        DataTable myDataTableRowWeighted;
        public MainWindow()
        {
            InitializeComponent();
            myDataTableColumnWeighted = new DataTable();
            myDataTableRowWeighted = new DataTable();
            var myItem = new List();
            for (int i = 0; i < 10000; i++)
            {
                myDataTableColumnWeighted.Columns.Add(new DataColumn("Column " + i));
                myItem.Add("entry " + i);
                var myOtherRow = myDataTableRowWeighted.NewRow();
                myDataTableRowWeighted.Rows.Add(myOtherRow);
            }
            var myRow = myDataTableColumnWeighted.NewRow();
            myRow.ItemArray = myItem.ToArray();
            myDataTableColumnWeighted.Rows.Add(myRow);
        }

        private void Button_Click(object sender, RoutedEventArgs e)
        {
            SeriesTableDataGrid.EnableColumnVirtualization = true;
            foreach (DataColumn col in myDataTableColumnWeighted.Columns)
            {
                SeriesTableDataGrid.Columns.Add(new DataGridTextColumn { Header = col.ColumnName });
            }
        }
        private void Button_Click2(object sender, RoutedEventArgs e)
        {
            var source = new CollectionViewSource();
            source.Source = myDataTableColumnWeighted;
            SeriesTableDataGrid.ItemsSource = myDataTableColumnWeighted.AsDataView();
        }

        private void Button_Click3(object sender, RoutedEventArgs e)
        {
            SeriesTableDataGrid.ItemsSource = myDataTableRowWeighted.AsDataView();
        }
        private void Button_Click4(object sender, RoutedEventArgs e)
        {
            SeriesTableDataGrid.Columns.Clear();
            SeriesTableDataGrid.ItemsSource = null;
        }
    }
}

WPF DataGrid initial column creation Virtualization

Answers (1)

Related Questions