Set Cell Text is too slow

[Hanson Liao]

Hi~

I have a StringCollection with size 100000. When using the following code to set each element to grid cell. It's very slow. (It spends about 10 seconds.)
Is there any way to speed up?

Thx!

-- code snippet --

Dim arrayValues As New StringCollection

arrayValues = ... 'Get arrayValues

For col As Integer = 1 To arraySize.Count
GridControl1(1, col).Text = arrayValues(col - 1)
Next

[Nirmal Raja]

Hi Hanson,

Thank you for your interest in Syncfusion products.

The Grid can be loaded with the data of collection with high performance and less number of time when you load the data's virtually. The QueryCellInfo event can be used to apply data to each cell virtually.

Please refer the sample from our sample browser in the below location:
{Install drive}:\Syncfusion\{Version Number}\Windows\Grid.Windows\Samples\2.0\Virtual Grid\Virtual Grid Tutorial

Let me know if you have any queries.

Regards,
Nirmal

[Hanson Liao]

Thank you! It works.

[Nirmal Raja]

Hi Hanson,

We are glad to hear that the issue has been resolved on your side.
Thank you for the update.

Regards,
Nirmal