How to build A WPF Datagrid with an unknown number of columns

by

There is DataTable class in .Net. Its primary purpose is to communicate with relational database but it can be used nicely to store, display and edit tabular data (e.g. read and display .csv/Excel files -> DataTable + DataGrid in wpf, DataTable + DataGridView in WinForms).

DataTable columns (DataColumn) can be added/removed at runtime and DataGrid auto-generates columns (DataGridColumn) for them (enabled by default), using Name property for headers. Also DataTable supports sorting and filtering out-of-box.

note: DataGrid doesn’t clear Columns when new ItemsSource is assigned. So it is possible to have some predefined columns and use autogenerate as well.

note: DataGrid creates DataGridTextColumns by default. If more complex template is required, the process can be intercepted via AutoGeneratingColumn event (see example)

here is an example:

code

public class MyViewModel
{
    public DataTable Test { get; set; }
}

public MyWindow()
{
    InitializeComponent();
    var vm = new MyViewModel
                {
                    Test = new DataTable
                        {
                            Columns = {"A", "B", "C"}
                        }
                };            
    this.DataContext = vm;

}

xaml

<DataGrid AutoGenerateColumns="True"
          ItemsSource="{Binding Path=Test.DefaultView}">
    <DataGrid.Columns>
        <DataGridTextColumn Header="#"/>
    </DataGrid.Columns>
</DataGrid>

the result (I entered some values)

datagrid

More Related Contents:

  1. Change DataGrid cell colour based on values
  2. How do I bind a WPF DataGrid to a variable number of columns?
  3. Select multiple items from a DataGrid in an MVVM WPF project
  4. Datagrid binding in WPF
  5. How can I set the color of a selected row in DataGrid
  6. How to hide wpf datagrid columns depending on a property
  7. DataGrid column width doesn’t auto-update
  8. Button in a column, getting the row from which it came on the Click event handler
  9. DataGrid row content vertical alignment
  10. Binding datagrid column width
  11. Sort a wpf datagrid programmatically
  12. Set focus on TextBox in WPF from view model
  13. How to hide close button in WPF window?
  14. Accessing UI (Main) Thread safely in WPF
  15. ReSharper WPF error: “Cannot resolve symbol “MyVariable” due to unknown DataContext”
  16. using of INotifyPropertyChanged
  17. Implement Validation for WPF TextBoxes
  18. ListBox items return string, when DataTemplate is Button
  19. Selecting a Textbox Item in a Listbox does not change the selected item of the listbox
  20. In WPF can you filter a CollectionViewSource without code behind?
  21. Use StringFormat to add a string to a WPF XAML binding
  22. the name does not exist in the namespace clr-namespace
  23. WPF Error 40 BindingExpression path error: property not found on ‘object’
  24. Cannot find source for binding with reference ‘RelativeSource FindAncestor’ [duplicate]
  25. How to sort TreeView items using SortDescriptions in Xaml?
  26. DataBinding in WPF?
  27. OneWayToSource Binding seems broken in .NET 4.0
  28. How to display items in Canvas through Binding
  29. WPF binding not updating the view
  30. Mutually exclusive checkable menu items?

Leave a Comment