Update Count/VirtualItemCount when datasource changes outside the application

[K]

Hey guys,

I have a RadGridView in the UI of my application and bind it to a VirtualQueryableCollectionView shown in the example:
https://docs.telerik.com/devtools/wpf/consuming-data/using-data-virtualization
That works fine so far.

Since I have a client/server architecture, it may happen that the server updates the database table collection is "looking" on.

Let's say there are 41 entries in the table after the UI started. Then the server adds one entry to the database. Afterwards the server notifies the client and the client executes "view.Refresh();".

Due to sorting the new entry may appear in the UI BUT the VirtualItemsCount remains 41.

I cannot find any method that allows me to refresh/update the underlying collection so that the collection is synchronized to the database.

Is it possible to achive this behavior or do I have to recreate the VirtualQueryableCollectionView with "view = new VirtualQueryableCollectionView (query);" on each refresh?

 

I appreciate any feedback :)

[K]

Edit: I use Version 2018.1.122.45

[K]

I found a workaround for this.

When the server send the notification, I call a Refresh method on the client.

The Refresh method first queries manually the count of items in the database table, then updates the VirtualQueryableCollection.VirtualItemsCount Property to the queried count and finally executes VirtualQueryableCollection's Refresh() method.

 

Found the idea here: https://www.telerik.com/forums/how-to-update-items-in-a-radgridview-with-virtualqueryablecollectionview

I came to this thread before but it seems I did not read it carefully.

[Dilyan Traykov]

Hello,

I'm glad to hear that you've found a solution to your issue and want to thank you for sharing your approach with the community.

Should you come across any other issues or any follow-up questions arise, don't hesitate to contact us again.

Regards,
Dilyan Traykov
Progress Telerik