DataGrid lazy loading

Oct 30, 2008 at 2:40 AM
I would like to bind the DataGrid to a big DataTable having hundreds of columns and thousands of rows. Many rows does not seem to be problem, but many columns is unworkable performance-wise.

Is it possible to bind the DataGrid to a DataTable in a 'lazy' way? Something like only loading cells that are currently visible in the DataGrid?

Thanks
Coordinator
Oct 30, 2008 at 3:26 AM
Hi JaapApp,

Have you tried setting EnableColumnVirtualization to true?  I don't believe this feature was included in the CTP, but the V1 version we released yesterday has it.  In our testing, we found that turning on column virtualization solved the performance issues even with over 100 columns.

If you do have column virtualization turned on already, then I'd be interested to learn more about your DataGrid, as this is definitely unexpected behavior.

Thanks!
Samantha
Oct 30, 2008 at 3:41 AM
Works like a charm!

I like! :-)

Cheers,

Jaap