Need Gridview to refresh data

[martin bertram]

I'm writing a multi-user application with WPF and I need the Rad Gridview to maintain fresh data as it may be changed by other users.  I'm using VB.NET and an ADO .NET entity for the business object.  How can this be done?

[Maya]

Hello martin bertram,

Please provide more details about your requirements and expected behavior. When exactly do you want your data to be refreshed ? Does the user change the whole data source or just some of the values inside the grid ? 

Greetings,
Maya
the Telerik team

[martin bertram]

The values of the data in the grid may be changed by other users in other programs and I need the grid to be able to display the current values and any new records, etc.  as quickly as possible while maintaining performance and without reseting the whole view for the user.  I've tried using gridview.Items.Refresh and it just crashes the application right away. 

[martin bertram]

OK I fixed the crashing for the refresh.  But the problem is now that I need it to refresh without disrupting the selected item, scroll position, etc. of the grid. 

[Pavel Pavlov]

Hi martin bertram,

Having in mind you do not want to reset the ItemsSource , here is one possible solution :

Your ItemsSource ( the collection that RadGridView is bound to ) should contain objects that implement the INotifyPropertyChanged interface.

When any user changes property in the object , it should properly raise the PropertyChanged event . This way RadGridView will sense the change and update the cell relevant to the changed value .

Let me know in case you need a sample on this.

Sincerely yours,
Pavel Pavlov
the Telerik team

[martin bertram]

Great.  Yes please provide a sample if you can.  Preferrably in vb.  Thanks

[Pavel Pavlov]

Hi martin bertram,


Please find the sample attached.  When you run it you will notice there are three  instances of RadGridView.  This is to simulate input form 3 different places ( e.g. 3 users) .

You can test it the following way:
Changing the Price value in one of the grids , will reflect immediately in the other grids , without disrupting the scroll or selection state of the other grids.

The trick is to raise the PropertyChanged event of the source object , when a value has changed by another user.


*please note  that for the purposes of the sample I have implemented the NotifyPropertyChanged pattern only for the "Price " field.

All the best,
Pavel Pavlov
the Telerik team

[Troy Goddu]

Pavel, I am doing some real time updating of our grids, but I have only used data binding.  My data is constructed within Entity Framework, mostly from a database.  My grids update but seem kind of slow.  Perhaps implementing INotifyPropertyChanged somewhere would help me.  Do you have a C# version of your sample? 

Sincerely,
RIchard

[Pavel Pavlov]

Hello Troy Goddu,

Please find the c# version attached.

Regards,
Pavel Pavlov
the Telerik team

[Troy Goddu]

Excellent!  Thank you very much, Pavel.

Sincerely,
Richard Craven

[Mike]

Hi we have the same problem of needing fresh data.  I downloaded the solution, and I see how it works, but isn't this kind of cheating?  All 3 grids in the same instance of the the application run.  Will it still work across users on the same intranet?  For example if User A updates the price on Workstation A, will User B on Workstation B also see that change immediately?

[Nick]

Hi Mike,

The solution that Pavel offered is the common mechanism that is used to notify multiple UIelements that are bound to the same object that there is a change in the source. Nevertheless, this will not work for multiple instances of the same application. The data synchronization that you are trying to achieve is a very complex problem that can be resolved by multiple solutions (Push up notifications, cyclomatic changes updates, etc.)

Hope this makes sense. 

Regards,
Nik
Telerik