Refresh grid content after changing datasource 2018

Hi Adam, 

Thank you for contacting Syncfusion support.

 

Setting SfDataGrid.DataSource to null is enough to reset a DataGrid to zero state. But while using busy indicator we have used BackgroundWorker to perform asynchronous operations. In such case, the reported issue will occur, since it tries to add the GroupColumnDescription before clearing the GroupColumnDescriptions collection. This behavior is confirmed as a defect and it will be fixed in our 2018 Volume 4 SP1 release which is expected to be rolled out in the end of January 2019. 

However, you can resolve this issue by clearing the GroupColumnDescriptions collection before adding a GroupColumnDescription. It is advisable to clear all the collections related to the MappingName of the columns as given in the code example. Please refer the following code example and sample from the given location. 

Code example:  

private void OnRefreshButtonClick(object sender, System.EventArgs e)  {      this.sfDataGrid.DataSource = null;      this.sfDataGrid.DataSource = data.OrdersListDetails;      this.sfDataGrid.ClearGrouping();      this.sfDataGrid.ClearSorting();      this.sfDataGrid.ClearFilters();      this.sfDataGrid.TableSummaryRows.Clear();      this.sfDataGrid.GroupSummaryRows.Clear();      this.sfDataGrid.GroupColumnDescriptions.Add(        new Syncfusion.WinForms.DataGrid.GroupColumnDescription()        {            ColumnName = "OrderID"        });  }

 

Sample link : http://www.syncfusion.com/downloads/support/directtrac/general/ze/CS-1193032875  

Regards, 

Deivaselvan 

Working very well

Thank you :-)

You are welcome.