How do I dynamically generate columns in a WPF DataGrid?

by

Ultimately I needed to do two things:

  1. Generate the columns manually from the list of properties returned by the query
  2. Set up a DataBinding object

After that the built-in data binding kicked in and worked fine and didn’t seem to have any issue getting the property values out of the ExpandoObject.

<DataGrid AutoGenerateColumns="False" ItemsSource="{Binding Results}" />

and

// Since there is no guarantee that all the ExpandoObjects have the 
// same set of properties, get the complete list of distinct property names
// - this represents the list of columns
var rows = dataGrid1.ItemsSource.OfType<IDictionary<string, object>>();
var columns = rows.SelectMany(d => d.Keys).Distinct(StringComparer.OrdinalIgnoreCase);

foreach (string text in columns)
{
    // now set up a column and binding for each property
    var column = new DataGridTextColumn 
    {
        Header = text,
        Binding = new Binding(text)
    };

    dataGrid1.Columns.Add(column);
}

More Related Contents:

  1. Binding Visibility for DataGridColumn in WPF
  2. WPF Error: Cannot find governing FrameworkElement for target element
  3. Get selected row item in DataGrid WPF
  4. How can I paginate a WPF DataGrid?
  5. WPF horizontal DataGrid
  6. How to perform Single click checkbox selection in WPF DataGrid?
  7. WPF Datagrid set selected row
  8. WPF datagrid header text binding
  9. Why can’t I style a DataGridTextColumn?
  10. Binding WPF DataGrid to DataTable using TemplateColumns
  11. How to access datagrid template column textbox text WPF C#
  12. WPF DataGrid validation errors not clearing
  13. What is the code behind for datagridtemplatecolumn, and how to use it?
  14. Create contextmenus for datagrid rows
  15. WPF: Bind DataGrid to List
  16. WPF DataGrid: Blank Row Missing
  17. Binding a WPF DataGridComboBoxColumn with MVVM
  18. how can I enable scrollbars on the WPF Datagrid?
  19. WPF datagrid selected row clicked event ?
  20. WPF Dynamic Layout with ItemsControl and Grid
  21. Filter a DataGrid on a Text box
  22. What is the proper way to handle multiple datagrids in a tab control so that cells leave edit mode when the tabs are changed?
  23. WPF MvvM DataGrid Dynamic Columns
  24. WPF DataGrid : CanContentScroll property causing odd behavior
  25. Binding DynamicObject to a DataGrid with automatic column generation?
  26. Keyboard shortcuts in WPF
  27. inherit style from default style
  28. Bind an element to two sources
  29. WPF window style not being applied
  30. Setting DataContext within UserControl is affecting bindings in parent

Leave a Comment