WPF DataGrid not displaying values of DataTable in certain columns

Question

I've got a program doing some processing of a CSV file and it's producing a DataTable as an output. I'm binding this to a DataGrid like so:

<DataGrid Name="GridTable" ItemsSource="{Binding OutputData}" />

Everything seems to work fine. The DataTable is produced, the DataGrid get's updated. But inexplicably the columns (type Double) don't seem to display their data. The first column (type int) works fine:

When I double check the DataTable structure it's all there, and all the correct type. I'm getting no exceptions:

DataTable

The data binding clearly works as it's showing the columns and has the correct value in the first column.

Has anyone come across this before? Cheers

B.S Lee · Accepted Answer · 2022-11-09 03:50:22Z

2

It's caused by the way you name the columnname. Try to get rid of '/' in the columnname. I had experienced the same issue when I put the dots in the columnname.

answered Nov 9, 2022 at 3:50

B.S Lee

331 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marcin · Accepted Answer · 2015-07-01 20:50:35Z

1

Did you use

<DataGrid.Columns>
<DataGridTextColumn Header="" Binding="{Binding }"/>
</DataGrid.Columns>

it should handle with doubles with no problem

answered Jul 1, 2015 at 20:50

Marcin

4377 silver badges21 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:58:55Z

0

Marcin's answer above led me to try binding columns individually, which led me here: programmatically add column & rows to WPF Datagrid

The solution was this:

            if (OutputData != null)
            {
                foreach (DataColumn col in OutputData.Columns)
                {
                    GridTable.Columns.Add(
                      new DataGridTextColumn
                      {
                          Header = col.ColumnName,
                          Binding = new Binding(string.Format("[{0}]", col.ColumnName))
                      });
                }

                GridTable.DataContext = OutputData;
            }

edited May 23, 2017 at 11:58

CommunityBot

11 silver badge

answered Jul 2, 2015 at 8:42

Joe

7,0944 gold badges57 silver badges88 bronze badges

Comments

Burak Atlı · Accepted Answer · 2018-06-18 13:48:08Z

0

i know that's been a long time, but if you are using db first integration, then nullable values are not showed in datagrid and also excel files. you can basically cast your nullable to int

answered Jun 18, 2018 at 13:48

Burak Atlı

11 bronze badge

Collectives™ on Stack Overflow

WPF DataGrid not displaying values of DataTable in certain columns

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related