How to bind DataTable to Datagrid

Question

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    lt DataGrid x Name  grid1  Margin  10  ItemsSource   Binding              AutoGenerateColumns  True  gt  lt  DataGrid gt    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

User · Answer

You could use DataGrid in WPF  SqlDataAdapter da   new SqlDataAdapter  Select   from Table  con   DataTable dt   new DataTable  Call Reciept    da Fill dt   DataGrid dg   new DataGrid    dg ItemsSource   dt DefaultView

User · Answer

In  cs file  grid DataContext   table DefaultView    In xaml file   lt DataGrid Name  grid  ItemsSource   Binding   gt

User · Answer

In cs file  DataTable employeeData   CreateDataTable    gridEmployees DataContext   employeeData DefaultView    In xaml file   lt DataGrid Name  gridEmployees  ItemsSource   Binding   gt

User · Answer

I m expecting  as Rohit Vats mentioned in his Comment too  that you have a wrong structure in your DataTable  Try something like this    var t   new DataTable          create column header   foreach   string s in identifiders         t Columns Add new DataColumn s        lt  lt     i m expecting you don t have defined any DataColumns  haven t you            Add data to DataTable   for   int lineNumber   identifierLineNumber  lineNumber  lt  lineCount  lineNumber           DataRow newRow   t NewRow        for   int column   0  column  lt  identifierCount  column             newRow column    fileContent ElementAt lineNumber  column             t Rows Add newRow          return t DefaultView   I have used this DataTable in a ValueConverter and it works like a charm with the following binding  xaml    lt DataGrid AutoGenerateColumns  quot True quot  ItemsSource  quot  Binding Path FileContent  Converter  StaticResource dataGridConverter   quot    gt   So what it does  the ValueConverter transforms my bounded data  what ever it is  in my case it s a List lt string   gt   into a DataTable  as the code above shows  and passes this DataTable to the DataGrid  With specified data columns the data grid can generate the needed columns and visualize them  To say it in a nutshell  in my case the binding to a DataTable works like a charm

User · Answer

using  SqlCeConnection con   new SqlCeConnection            con ConnectionString   connectionString     con Open       SqlCeCommand com   new SqlCeCommand  SELECT S no Name Father Name      SqlCeDataAdapter sda   new SqlCeDataAdapter com      System Data DataTable dt   new System Data DataTable       sda Fill dt      dataGrid1 ItemsSource   dt DefaultView     dataGrid1 AutoGenerateColumns   true     dataGrid1 CanUserAddRows   false

User · Answer

In cs file       private DataTable  dataTable       public DataTable DataTable               get   return  dataTable            set    dataTable   value               private void Window Loaded object sender  RoutedEventArgs e                this  dataTable   new DataTable  table             this  dataTable Columns Add  col0            this  dataTable Columns Add  col1            this  dataTable Columns Add  col2             this  dataTable Rows Add  data00    data01    data02            this  dataTable Rows Add  data10    data11    data22            this  dataTable Rows Add  data20    data21    data22             this grid1 DataContext   this           In Xaml file    lt DataGrid x Name  grid1            Margin  10            AutoGenerateColumns  True            ItemsSource   Binding Path DataTable  Mode TwoWay     gt

User · Answer

I d do it this way   grid1 DataContext   dt AsEnumerable   Where x   gt  x  lt  10  AsEnumerable   CopyToDataTable   AsDataView      and do whatever query i want between the two AsEnumerable    If you don t need space for query  you can just do directly this   grid1 DataContext   dt AsDataView

[c#] How to bind DataTable to Datagrid

Examples related to c#

Examples related to wpf

Examples related to datagrid

Examples related to datatable