Data is visible in DataSet visualizer but does not show in a DataGrid

by

When DataGrid generates columns for its ItemsSource, it uses DataTable column names as binding path for columns. While / symbol is valid in DataColumn names, in has a special meaning in binding path and should be escaped if it is a part of name, e.g. [80/4] not 80/4

add event handler to AutoGeneratingColumn event in xaml:

AutoGeneratingColumn="Dg_OnAutoGeneratingColumn"

and modify bindings with this code:

private void Dg_OnAutoGeneratingColumn(object sender, DataGridAutoGeneratingColumnEventArgs e)
{
    var textCol = e.Column as DataGridTextColumn;
    if (textCol == null)
        return;
    var binding = textCol.Binding as Binding;
    if (binding == null)
        return;
    binding.Path = new PropertyPath("[" + binding.Path.Path + "]");
}

More Related Contents:

  1. How to bind DataTable to Datagrid
  2. How to get ToolTip from WPF Data Grid Column Header (DataGridTemplateColumn) in code?
  3. Change DataGrid cell colour based on values
  4. Accessing UI (Main) Thread safely in WPF
  5. programmatically add column & rows to WPF Datagrid
  6. Select multiple items from a DataGrid in an MVVM WPF project
  7. Datagrid binding in WPF
  8. DataGrid get selected rows’ column values
  9. WPF iterate through datagrid
  10. DataGrid shows path of image instead of image itself
  11. How can I set the color of a selected row in DataGrid
  12. Improve WPF DataGrid performance
  13. How to hide wpf datagrid columns depending on a property
  14. DataGrid column width doesn’t auto-update
  15. WPF Datagrid Get Selected Cell Value
  16. How to loop over the rows of a WPF toolkit Datagrid
  17. How to build A WPF Datagrid with an unknown number of columns
  18. Button in a column, getting the row from which it came on the Click event handler
  19. Merge Cells in WPF DataGrid
  20. DataGrid row content vertical alignment
  21. WPF DataGrid: DataGridComboxBox ItemsSource Binding to a Collection of Collections
  22. FindVisualChild reference issue
  23. OpenClipboard failed when copy pasting data from WPF DataGrid
  24. How do I bind a List to a WPF DataGrid?
  25. ScrollIntoView for WPF DataGrid (MVVM)
  26. Binding datagrid column width
  27. WPF DataGrid – Event for New Rows?
  28. How to bind column header to property in ViewModel? (WPF MVVM)
  29. Add context menu in datagrid, how to get the select Item value
  30. Sort a wpf datagrid programmatically

Leave a Comment