RadGridView not refreshing correctly on dbContext.refresh

[Alexander]

I have a strange problem and am looking into it for two days now.

I want to achieve that the radgridview's data is refreshed with the latest data from the database with no noticable delay in UI. So I definately don't want to do a rebind.
The grid's ItemsSource binds to an OberservableCollection(Of poco).
The thing I do is send this ObservableCollection to the dbContext (Telerik DataAccess EntitiesModel class):

dbContext.Refresh(Telerik.OpenAccess.RefreshMode.OverwriteChangesFromStore, toPoco)
After this refresh I fire the PropertyChanged event of the property holding the ObservableCollection.

Here's what happens:
Gridview's UI isn't updated. When I scroll the grid so a gridrow that has been changed is out of view and scroll the changed row back into view, the gridrow does show the right (changed!) data from SQL server.

It looks like the grid isn't getting a signal that the collection has been changed so it doen't update it's UI.

What could i do to refresh the gridview the right way?

Alexander

[Dimitrina]

Hello Alexander,

You need to raise a CollectionChange notification in order to get the UI reflect the changes from the DataBase.

You can check the approach from the Update item outside RadGridView help article. That way such a notification will be raised just for the item being actually changed. 

The items will also be updated if you invoke a RadGridView.Rebind() or just sort on any column to perform a simple test.

You say that when you scroll the grid so a grid row that has been changed is out of view and scroll the changed row back into view, the gridrow does show the right. This should be as of the UI Virtualization that is enabled by default.

Regards,
Didie
Telerik

 

 

[Alexander]

Ok, I ended up doing a rebind of the gridview.

Wichleads me to another problem: I have a DataForm that has to be refreshed too and that has no rebind option.
The only way I found was by saving, clearing and restoring the previously saved DataForm's CurrentItem. 
Is there a better way to do that?

It would be nice if a (DataAccess) dbcontext.Refresh of the poco object would reflect it's changes in the UI automatically...

[Dimitrina]

Hi,

Basically our controls update the UI based on the notifications received from their source (ItemsSource).
If a property of the bound item is changed, then the UI will update once a PropertyChanged notification is received.
In case the collection itself is changed, i.e. an item is added or removed, you should raise a CollectionChanged notification as I explained in my previous post.

Having this in mind, in order to refresh the changes on an existing item, you POCO objects should implement the INotifyPropertyChanged interface.

As a side note, please keep in mind that dbContext.Refresh() will perform a refresh on the existing items only. If you would like to also get the inserted or removed items up to date, then you should invoke the query again.

Regards,
Didie
Telerik

 

 

[William]

My RadGridView is NOT refreshing after the underlying data is changed.

These are the statements that have been added:

                this.COResultsGrid.ItemsSource = null;

                this.COResultsGrid.ItemsSource = MyViewModel.Document.COResults;
                this.COResultsGrid.Items.Refresh();

               this.COResultsGrid.Rebind();

 

Routine INotifyPropertyChanged is used for all property sets.

 

[Dilyan Traykov]

Hello William,

Could you please share more details on the exact setup at your end, as, technically, simply calling the Rebind method will update RadGridView's ItemsSource?

Sending over some code snippets of your RadGridView as well as its bound collection would definitely be of help.

Thank you in advance for your cooperation on the matter.

Regards,
Dilyan Traykov
Telerik by Progress