How to load a datatable into wpf data grid

Question

I'm trying to display the content of a datatable in my wpf datagrid

In the following post:

Why can't I bind the WPFToolkit DataGrid ItemSource to DataTable?

I found the code:

myDataGrid.ItemsSource = myDataTable.DefaultView;

and the behaviour is strange: it shows n empty rows where the n is correct: the query results n rows!

So why can't I see them?

+1 yes I already found it... myGrid.AutoGenerateColumns = true; that indeed was the problem. — Asaf, Nov 09 '10 at 15:57

score 3 · Accepted Answer · edited Dec 04 '14 at 11:07

3

Without seeing the code, I would guess that you don't have AutoGenerateColumns set to to true. That's fine, but if you aren't auto-generating columns, you need to manually add column definitions to your data grid.

edited Dec 04 '14 at 11:07

akjoshi

15,374
13
103
121

answered Nov 09 '10 at 14:37

Adam Barney

2,377
3
18
24

score -2 · Answer 2 · answered Nov 09 '10 at 13:55

-2

One possible solution would be to replace the DataGrid with a DataGridView and bind the DataGridView.DataSource property to the DataTable itself. As per this example:

dataGrid1.DataSource = table;

answered Nov 09 '10 at 13:55

vlad

4,748
2
30
36

1

We are talking about WPF. DataGridView is a WinForms control. – TecMan Sep 28 '16 at 07:44

How to load a datatable into wpf data grid

2 Answers2

Linked