We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Load many cell values at once?

Thread ID:





95279 Jun 29,2010 09:09 PM UTC Jul 2,2010 02:40 PM UTC Silverlight 3
Tags: GridControl
Administrator [Syncfusion]
Asked On June 29, 2010 09:09 PM UTC

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?


Muthulakshmi N [Syncfusion]
Replied On July 1, 2010 12:04 PM UTC

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.


Administrator [Syncfusion]
Replied On July 1, 2010 03:12 PM UTC

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 [Syncfusion]
Replied On July 2, 2010 02:40 PM UTC

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.


Let us know if you need any other details.

Jeraldes J


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon