Hi Admins

Previously i was using Default DataGridView for populating a Table.

It was working fine. But due to advace Functionality of RadGridView, I have develop the same with Telerik Controls (R2 SP1 2019).

But i have some Performance Issues.

Check the Sample Code and please suggest me for Performance Enhancement.

I'm Creating Column at Run Time Using This Code and Setting Grid Properties.

 

I'm creating 10 different Columns using the Above Code.

Using the Below Code loading the Data to GridView

 

I have shown you only 1 Column only to shorten my Code.

Please Suggest.

Is it any Performance issue to create columns and Setting of RadGridView at Run-time instead of Design-Time

Hello, Muhammad, 

According to the provided code snippet, it seems that you populate the columns in RadGridView programmatically. I suppose that the AutoGenerateColumns property is set to false. Thus, when you set the RadGridView.DataSource, the already added columns will be used. Everything seems to be pretty straight-forward. That is why it is difficult to determine what causes the performance problems that you mentioned. 

Could you please specify how many rows you load in RadGridView?

If you have a large number of rows in the grid, it would be good to consider using RadVirtualGrid. It is a grid component developed on top of Telerik Presentation Framework which provides a convenient way to implement your own data management operations and optimizes the performance when interacting with large amounts of data: https://docs.telerik.com/devtools/winforms/controls/virtualgrid/overview

However, if you insist on using RadGridView, I would kindly ask you to submit a support ticket and provide additional information how to replicate the undesired behavior that you are facing. A sample project would be very useful for further investigating the case. Thus, our support staff will gladly assist you.

Note that most of the forum threads are reviewed by Telerik representatives and sometimes we address the questions asked by our customers in the forums as well. However, a post in the forum doesn't guarantee you a response from the Telerik support team. Moreover, threads are handled according to license and time of posting, so if it is an urgent problem, we suggest you use a support ticket, which would be handled before a forum thread.

Thank you for your understanding.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Thanks for your kind reply.

Yes i populating the data programmatically with AutoGenrateColumns=False.

Right now the grid only populate 300 Rows.

I will try to use VirtualGrid.

Can you Guide me How can i Populate the Grid only after Form is Fully displayed on screes.

 

Required Little Explanation for this Code of lines.

These are used at Many places in the Demo provided.

Does this help to overcome performance Issues.

 

Thanks

Hello, Muhammad,     

Indeed, using RadGridView.BeginUpdate and RadGridView.EndUpdate methods are the suitable approach for improving performance when adding multiple rows programmatically. Note that when you add a row, this will refresh the grid. Hence, if you add 300 rows, 300 refresh operations will be performed. But it is not necessary. You need to refresh just once after the last row is added. That is why call the RadGridView.BeginUpdate method before adding the rows and the RadGridView.EndUpdate method after adding the rows which will suspend the layout while you are adding rows and only at the end the grid will be refreshed.

I hope this information helps.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik