How add row in DataGrid WPF

Question

I do not understand how to write content from a database to a DataGrid. Here is the code Code DataGrid

<DataGrid AutoGenerateColumns="False" x:Name="ColorsTable" HorizontalGridLinesBrush="DarkGray"
                                        RowBackground="LightGray" AlternatingRowBackground="White" Grid.ColumnSpan="2" Margin="0,0,624.2,0">
                                <DataGrid.Columns>
                                    <DataGridTextColumn Header="ID" Binding="{Binding Path = Id}" Width="100" />
                                    <DataGridTextColumn Header="Name" Binding="{Binding Path = Name}" Width="100" />
                                    <DataGridTextColumn Header="Specification" Binding="{Binding Path = Specification}" Width="100" />
                                </DataGrid.Columns>
                            </DataGrid>

Code add

ObservableCollection<SomeAbstact> temp = new ObservableCollection<SomeAbstact>();
            sqlCommand = new SqlCommand("SELECT * FROM [Colors]", SqlConnection);
            reader = await sqlCommand.ExecuteReaderAsync();
            while (await reader.ReadAsync())
            {
                temp.Add(new Colors()
                {
                    Id = Convert.ToInt32(reader["Id"]),
                    Name = reader["Name"].ToString(),
                    Specification = reader["Description"].ToString()
                });
            }
            ColorsTable.ItemsSource = temp;
            temp.Clear();
            reader.Close();

Entity add

public class Colors: SomeAbstact
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Specification { get; set; }
}

temp.Clear(); why are you doing this bro ? you are using this list as ItemSource of DataGrid and after assigning you are Clearing the List ? Don't clear the List. — Hammas
– Hammas, Commented Apr 2, 2020 at 14:05
Also Binding="{Binding Path = Id}" instead you can do this Binding="{Binding Id}" — Hammas
– Hammas, Commented Apr 2, 2020 at 14:06

NX ENGINEERING · Accepted Answer · 2020-04-02 14:13:09Z

1

You can bind the DataGrid to the ObservableCollection like this:

<DataGrid ItemsSource="{Binding temp}">
        <DataGrid.Columns>
            <DataGridTextColumn Binding="{Binding Id}"/>
            <DataGridTextColumn Binding="{Binding Name}"/>
            <DataGridTextColumn Binding="{Binding Specification}"/>
        </DataGrid.Columns>
    </DataGrid>

This will only work if the DataContext is set properly. Also you should check out how to implement INotifyPropertyChanged if you want to use bindings in WPF.

answered Apr 2, 2020 at 14:13

NX ENGINEERING

434 bronze badges

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

Collectives™ on Stack Overflow

How add row in DataGrid WPF

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related