How to bind DataTable to Datagrid

c# wpf datagrid datatable
Cygu picture Cygu · Dec 25, 2013 · Viewed 150.4k times · Source

I have a problem binding a DataTable to a DataGrid. I have already searched for solutions but just can't get rid of the error. The binding works fine when using WindowsForms, so the DataTable is correct. I just can't bind it to a WPF-DataGrid.

Error message: AmbiguousMatchException was unhandled
Source: mscorlib

I have already set up new project to get rid of any bad links, etc.

XAML-Code:

<DataGrid x:Name="grid1" Margin="10" ItemsSource="{Binding}" 
          AutoGenerateColumns="True"></DataGrid>

I have already tried following C#-Code behind:

grid1.ItemsSource = dt.DefaultView;

or

grid1.DataContext = dt.DefaultView;

or

grid1.DataContext = dtex;

Any help is appreciated.

Answer

Krishan Ahlawat picture Krishan Ahlawat · Feb 22, 2014

In cs file

DataTable employeeData = CreateDataTable();
gridEmployees.DataContext = employeeData.DefaultView;

In xaml file

<DataGrid Name="gridEmployees" ItemsSource="{Binding}">

Related questions

programmatically add column & rows to WPF Datagrid

I'm new to WPF. I just want to know how should we add columns and rows programmatically to a DataGrid in WPF. The way we used to do it in windows forms. create table columns and rows, and bind it …

Read More
Datagrid binding in WPF

I know this has been asked already but I have done almost everything what is suggested by developers. <DataGrid x:Name="Imported" VerticalAlignment="Top" DataContext="{Binding Source=list}" AutoGenerateColumns="False" CanUserResizeColumns="True"> <DataGrid.Columns> <DataGridTextColumn …

Read More
DataGrid get selected rows' column values

I'm trying to get the values of each column of a selected row in a DataGrid. This is what I have: private void dataGrid1_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e) { DataGrid dg = sender as DataGrid; Console.WriteLine(dg.SelectedCells[0].ToString()); } But …

Read More