Load many cell values at once?

[Administrator]

What is the fastest way to load many cell values?

Our previous Grid had a SetValueArray() method to set an entire array of cell values. Is there something similar with the SyncFusion grid?

thanks,
Jaimie

[Muthulakshmi N]

Hi Jaimie,

Thank you for your interest in Syncfusion Products.

We can populate GridControl with QueryCellInfo or using loops. We don’t have a separate method to populate the data , but you can use extension methods to achieve this requirement. We have a sample Virtual Grid Demo in our Dahsborad. Virtual grids allow you to display large data sources very quickly. In this sample, the Grid Control displays 99,000,000 x 10,000 cells.

The sample can be found in the following location:
EssentialGrid -> Grid Virtualization -> Virtual Grid Demo

Let us know if you need any other details.

Regards
Muthulakshmi.N

[Administrator]

I was thinking of using the QueryCellInfo() for speed, but the thing I was worried about is how ResizeColumnsToFit() would work if the grid doesn't know about all the data. Our customers expect that the columns are sized correctly for the data.

[Jeraldes J]

Hi Jaimie

Yes, you can use QueryCellInfo() to load the cells but you have to declare the ResizeColumnToFit() after the querycell. This would help you in fitting the grid to the data in the cell.

Please refer with the below sample for your reference.

http://www.syncfusion.com/uploads/redirect.aspx?file=GC-QueryCell-95279_9ac8c961.zip&team=development

Let us know if you need any other details.

Regards
Jeraldes J