How to refresh datagrid in WPF

Question

My source is in a MySQL database, I've made an update command and now I need to refresh my DataGrid.

MySqlCommand cmd = new MySqlCommand(
  "update request set status = " + StatusRequest(value) + 
  " where id = " + rowView[0].ToString() + "", conn);
MySqlDataReader myReader = cmd.ExecuteReader();

How do I refresh my DataGrid?

Answer 1

From MSDN -

CollectionViewSource.GetDefaultView(myGrid.ItemsSource).Refresh();

Answer 2

Try mydatagrid.Items.Refresh()

Answer 3

Reload the datasource of your grid after the update

myGrid.ItemsSource = null;
myGrid.ItemsSource = myDataSource;

Answer 4

Bind you Datagrid to an ObservableCollection, and update your collection instead.

Answer 5

How about

mydatagrid.UpdateLayout();

Answer 6

I had a lot of trouble with this and this is what helped me get the DataGrid reloaded with the new values. Make sure you use the data type that your are getting the data from to get the latest data values.

I represented that with SomeDataType below.

DataContext.Refresh(RefreshMode.OverwriteCurrentValues, DataContext.SomeDataType);

Hope this helps someone with the same issues I had.