What is the best working strategy for data grid when working with very large datasets

[itg-assistant]

Stanislaw Tristan asked 2017-03-28 20:49:52 UTC

Hello!

Is datagrid works in virtual mode? I need not to store the entire dataset in memory, but load portions of data from database by request from datagrid. What options I have?

[itg-assistant]

Frank (ITG) answered 2017-03-29 01:01:07 UTC

Hi Stanislaw,

The DataGridView (as well as ListView, FullCalendar etc.) fully supports virtual mode like in WinForms.

However, we didn't implement shared rows yet. It will be completed shortly (in a few weeks).

The functionality of shared rows will be completely transparent  to the code and virtual scrolling.

Hope that helps.

Best regards
Frank

[itg-assistant]

Stanislaw Tristan answered 2017-03-29 11:03:25 UTC

Frank, thank you for the information – will play with virtual mode.

[itg-assistant]

Mark Reed answered 2017-03-29 17:10:41 UTC

Here is some code fragments that might help that I am using at the moment.

[itg-assistant]

Stanislaw Tristan answered 2017-03-29 17:14:14 UTC

Mark, Thank you for sharing!

[itg-assistant]

Mark Reed answered 2017-03-29 18:19:56 UTC

Here is maybe a slightly better example using a derived class.