Hi Andrew,
Thanks for writing back. Basically, the
Data Cache object represents the current data loaded from the database in the memory of your machine. This object makes sure that only the needed data is available for display. In other words, when you have 1.5 Million rows of information in your database and you want to display them to the user, only certain rows are downloaded from the database and stored in the computer memory. The cache object determines which rows are downloaded and how are they stored. For instance, you may want to download the first 20 rows and display them. After the user scrolls, you may want to download 20 rows with an offset 2 from the first row and display them etc. In general, when using the RadGridViewControl in Virtual Mode, you define the way the control interacts with its data source.
Unfortunately, we do not have examples how to design a caching mechanism since different scenarios require different implementations. However, there is a helpful article in MSDN that should give you the idea of how you could build your caching mechanism:
Implementing Virtual Mode with Just-In-Time Data Loading in the Windows Forms DataGridView Control
I have also prepared a simple code snippet that demonstrates how to prepare the RadMultiColumnComboBox control for Virtual Mode:
RadMultiColumnComboBox does not support AutoComplete in Virtual Mode. You can, however, use the
TextChanged event to give the user hints of possible matches to their input.
I hope these hints are helpful.
Greetings,
Deyan
the Telerik team