Refresh grid content after changing datasource 2018

[Adam]

I have still a problems with sfDataGrid after change DataSource.

I fond a topic from 2007 https://www.syncfusion.com/forums/62003/refresh-grid-content-after-changing-datasource but it don´t working any more ;-)

So here my question: how I can completly reset a DataGrid to "zero status"

I try it with:

dGrid.DataSource = null;

dGrid.Refresh();

so was ok... BUT if I using

dGrid.ShowBusyIndicator = true;

on the line

dGrid.Add(new GroupColumnDescription() { ColumnName = "DispayStatus" });

come error:

GroupColumnDescription already exist in DataGrid.GroupColumnDescriptions

I try also clear that (before Refresh) with:

dGrid.GroupColumnDescriptions.Clear();

but become error:

The object reference was not set to an object instance

Do you have some new update for this issue? Thanks

[Deivaselvan Y]

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 

[Adam]

Working very well

Thank you :-)

[Deivaselvan Y]

You are welcome.