For more information on how to implement virtual mode for the RadGridView
, please take a look at this help article
But i have to warn you that from what i now, RadGridView
does not process filtering, sorting, and grouping in Virtual Mode
. Only the UI and expression collections are updated.
You can use FilterChanged
, and GroupByChanged
implement you logic for virtual mode. The events notify for a change in
the related expression collections and send updates to RadGridView UI to
event to fill again the displayed cells in the current grid view.
There were some plans to include this in the future versions, but from what i know this hasn't happened yet.
But as the previous replies have stated, the fact of the matter is with Linq you are getting just the data you can see, and from what i understand, this could be a problem in your case because you need to be able to change the values on the entire DataSet, DataTable?
Another easier option is to use a timer, that would perform a refresh every x seconds.
Hope this helps, if you have any other questions or comments, please let me know,