Refresh DataGridView when updating data source

Question

What is the best way to refresh a DataGridView when you update an underlying data source   I m updating the datasource frequently and wanted to display the outcome to the user as it happens   I ve got something like this  and it works   but setting the DataGridView DataSource to null doesn t seem like the right way   List lt ItemState gt  itemStates   new List lt ItemState gt     dataGridView1 DataSource   itemStates   for  int i   0  i  lt  10  i           itemStates Add new ItemState   Id   i ToString           dataGridView1 DataSource   null      dataGridView1 DataSource   itemStates      System Threading Thread Sleep 500

User · Answer

You are setting the datasource inside of the loop and sleeping 500 after each add. Why not just add to itemstates and then set your datasource AFTER you have added everything. If you want the thread sleep after that fine. The first block of code here is yours the second block I modified.

for (int i = 0; i < 10; i++) { 
    itemStates.Add(new ItemState { Id = i.ToString() });
    dataGridView1.DataSource = null;
    dataGridView1.DataSource = itemStates;
    System.Threading.Thread.Sleep(500);
}

Change your Code As follows: this is much faster.

for (int i = 0; i < 10; i++) { 
    itemStates.Add(new ItemState { Id = i.ToString() });

}
    dataGridView1.DataSource = typeof(List); 
    dataGridView1.DataSource = itemStates;
    System.Threading.Thread.Sleep(500);

User · Answer

Try this Code  List itemStates   new List     for  int i   0  i  lt  10  i           itemStates Add new ItemState   Id   i ToString           dataGridView1 DataSource   itemStates      dataGridView1 DataBind        System Threading Thread Sleep 500

User · Answer

Well  it doesn t get much better than that  Officially  you should use  dataGridView1 DataSource   typeof List    dataGridView1 DataSource   itemStates    It s still a  clear reset source  kind of solution  but I have yet to find anything else that would reliably refresh the DGV data source

User · Answer

The cleanest  most efficient and paradigm-friendly solution in this case is to use a System Windows Forms BindingSource as a proxy between your list of items  datasource  and your DataGridView   var itemStates   new List lt ItemState gt     var bindingSource1   new System Windows Forms BindingSource   DataSource   itemStates    dataGridView1 DataSource   bindingSource1    Then  when adding items  use Add   method of BindingSource instead of your list s Add   method   for  var i   0  i  lt  10  i          bindingSource1 Add new ItemState   Id   i ToString           System Threading Thread Sleep 500       This way you adding items to your list and notifying DataGridView about those additions with the same line of code  No need to reset DataGridView s DataSource every time you make a change to the list   It also worth mentioning that you can drop a BindingSource onto your form directly in Visual Studio s Forms Designer and attach it as a data source to your DataGridView there as well  which saves you a line of code in the above example where I m doing it manually

User · Answer

Well  it doesn t get much better than that  Officially  you should use  dataGridView1 DataSource   typeof List    dataGridView1 DataSource   itemStates    It s still a  clear reset source  kind of solution  but I have yet to find anything else that would reliably refresh the DGV data source

User · Answer

Alexander Abakumov s answer is the correct one  It solved every binding issue I had  updating the underlying data and having the grid update    Its easy to implement and modify any existing source code you have   grdDetails DataSource   new System Windows Forms BindingSource   DataSource   OrderDetails

User · Answer

Observablecollection  Represents a dynamic data collection that provides notifications  when items get added  removed  or when the whole list is refreshed  You can enumerate over any collection that implements the IEnumerable interface   However  to set up dynamic bindings so that insertions or deletions in the  collection update the UI automatically   the collection must implement the INotifyCollectionChanged interface   This interface exposes the CollectionChanged event   an event that should be raised whenever the underlying collection changes   Observablecollection lt ItemState gt  itemStates   new Observablecollection lt ItemState gt      for  int i   0  i  lt  10  i           itemStates Add new ItemState   Id   i ToString            dataGridView1 DataSource   itemStates

User · Answer

You are setting the datasource inside of the loop and sleeping 500 after each add. Why not just add to itemstates and then set your datasource AFTER you have added everything. If you want the thread sleep after that fine. The first block of code here is yours the second block I modified.

for (int i = 0; i < 10; i++) { 
    itemStates.Add(new ItemState { Id = i.ToString() });
    dataGridView1.DataSource = null;
    dataGridView1.DataSource = itemStates;
    System.Threading.Thread.Sleep(500);
}

Change your Code As follows: this is much faster.

for (int i = 0; i < 10; i++) { 
    itemStates.Add(new ItemState { Id = i.ToString() });

}
    dataGridView1.DataSource = typeof(List); 
    dataGridView1.DataSource = itemStates;
    System.Threading.Thread.Sleep(500);

User · Answer

This is copy my answer from THIS place   Only need to fill datagrid again like this   this XXXTableAdapter Fill this DataSet XXX     If you use automaticlly connect from dataGridView this code create automaticlly in Form Load

User · Answer

This is copy my answer from THIS place   Only need to fill datagrid again like this   this XXXTableAdapter Fill this DataSet XXX     If you use automaticlly connect from dataGridView this code create automaticlly in Form Load

User · Answer

Try this Code  List itemStates   new List     for  int i   0  i  lt  10  i           itemStates Add new ItemState   Id   i ToString           dataGridView1 DataSource   itemStates      dataGridView1 DataBind        System Threading Thread Sleep 500

User · Answer

Try this Code  List itemStates   new List     for  int i   0  i  lt  10  i           itemStates Add new ItemState   Id   i ToString           dataGridView1 DataSource   itemStates      dataGridView1 DataBind        System Threading Thread Sleep 500

User · Answer

The cleanest  most efficient and paradigm-friendly solution in this case is to use a System Windows Forms BindingSource as a proxy between your list of items  datasource  and your DataGridView   var itemStates   new List lt ItemState gt     var bindingSource1   new System Windows Forms BindingSource   DataSource   itemStates    dataGridView1 DataSource   bindingSource1    Then  when adding items  use Add   method of BindingSource instead of your list s Add   method   for  var i   0  i  lt  10  i          bindingSource1 Add new ItemState   Id   i ToString           System Threading Thread Sleep 500       This way you adding items to your list and notifying DataGridView about those additions with the same line of code  No need to reset DataGridView s DataSource every time you make a change to the list   It also worth mentioning that you can drop a BindingSource onto your form directly in Visual Studio s Forms Designer and attach it as a data source to your DataGridView there as well  which saves you a line of code in the above example where I m doing it manually

User · Answer

Try this Code  List itemStates   new List     for  int i   0  i  lt  10  i           itemStates Add new ItemState   Id   i ToString           dataGridView1 DataSource   itemStates      dataGridView1 DataBind        System Threading Thread Sleep 500

User · Answer

Well  it doesn t get much better than that  Officially  you should use  dataGridView1 DataSource   typeof List    dataGridView1 DataSource   itemStates    It s still a  clear reset source  kind of solution  but I have yet to find anything else that would reliably refresh the DGV data source

User · Answer

Observablecollection  Represents a dynamic data collection that provides notifications  when items get added  removed  or when the whole list is refreshed  You can enumerate over any collection that implements the IEnumerable interface   However  to set up dynamic bindings so that insertions or deletions in the  collection update the UI automatically   the collection must implement the INotifyCollectionChanged interface   This interface exposes the CollectionChanged event   an event that should be raised whenever the underlying collection changes   Observablecollection lt ItemState gt  itemStates   new Observablecollection lt ItemState gt      for  int i   0  i  lt  10  i           itemStates Add new ItemState   Id   i ToString            dataGridView1 DataSource   itemStates

User · Answer

Well  it doesn t get much better than that  Officially  you should use  dataGridView1 DataSource   typeof List    dataGridView1 DataSource   itemStates    It s still a  clear reset source  kind of solution  but I have yet to find anything else that would reliably refresh the DGV data source

User · Answer

I ran into this myself   My recommendation   If you have ownership of the datasource  don t use a List   Use a BindingList   The BindingList has events that fire when items are added or changed  and the DataGridView will automatically update itself when these events are fired

User · Answer

Alexander Abakumov s answer is the correct one  It solved every binding issue I had  updating the underlying data and having the grid update    Its easy to implement and modify any existing source code you have   grdDetails DataSource   new System Windows Forms BindingSource   DataSource   OrderDetails

User · Answer

I ran into this myself   My recommendation   If you have ownership of the datasource  don t use a List   Use a BindingList   The BindingList has events that fire when items are added or changed  and the DataGridView will automatically update itself when these events are fired

[c#] Refresh DataGridView when updating data source

Examples related to c#

Examples related to .net

Examples related to winforms

Examples related to datagridview