RadGridView - Copying Huge Amount of Rows

[Adriano]

 Hi,

 

I'm having an issue with Silverlight using RadGridView once I copy data from the grid (selecting the row/cells and CTRL + C). It works fine when I try to copy 1.000 rows with 12 columns (some with GridViewComboBox columns, some with numeric and string values), but when I try to copy 100.000 rows it stop working and freezes the whole page.

Is there any possible way to improve performance on copying so many rows from RadGridView?

So far the only tratment I'm doing is regarding CopyingCellClipboardContent:

        private void radGridView_CopyingCellClipboardContent(object sender, GridViewCellClipboardEventArgs e)
        {
            if (e.Value == null)
            {
                e.Value = string.Empty;
            }
        }

Do you have any input that I can try in order to make this Copy possible?

Adriano

[Maya]

Hi Gasper,

I just replied to the forum thread posted on the same topic.  

Regards,
Maya
Telerik

[Adriano]

Maya,

 

I notice one weird behavior, on your sample it freezes the browser for a while and I can't continue working. It's a lot less time than my project but it freezes, do you face this issue? If so is there anyway to solve it?

 

I tried to handled copy by myself (using Telerik.Windows.Controls.Clipboard.SetText("Values");) but couldn't find a fast logic, if you have any I would be glad.

 

Another difference comparing to my project is that almost all columns are GridViewComboBox columns but on yours they are GridViewDataColumn, doesn't kown if this is part of the issue.

 

By the way do you think this freeze maybe memory related?

Thanks,

Adriano Gaspar.

[Maya]

Hi Gasper,


I tried again to get the browser freezing, but without success. Copying the items works pretty fast and the slower operation is pasting (in my case in notepad file). As for working with GridViewComboBoxColumn-s, it is expected to get small performance degradation since the data should be found through the lookup element rather than just by getting the value of the column. 
What you can try is to use BackgroundWorker and perform the pasting on a separate thread. However, this will require to cancel Copying event and copy the values of the items on your own. 


Regards,
Maya
Telerik

[Adriano]

OK, I'll try to execute the Copy on a background process and cancelling RadGridView event.

 

Thanks for you support.