Hello James,
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,
SortChanged, and
GroupByChanged events to
implement you logic for virtual mode. The events notify for a change in
the related expression collections and send updates to RadGridView UI to
fire
CellValueNeeded 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,
Best Regards,
Emanuel Varga