RadGridView - Copying Huge Amount of Rows

5 posts, 1 answers
  1. Adriano
    Adriano avatar
    19 posts
    Member since:
    Jul 2012

    Posted 20 May 2015 Link to this post

     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

  2. Maya
    Admin
    Maya avatar
    4062 posts

    Posted 21 May 2015 Link to this post

    Hi Gasper,

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

    Regards,
    Maya
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
  4. Adriano
    Adriano avatar
    19 posts
    Member since:
    Jul 2012

    Posted 22 May 2015 in reply to Maya Link to this post

    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.

  5. Answer
    Maya
    Admin
    Maya avatar
    4062 posts

    Posted 25 May 2015 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  6. Adriano
    Adriano avatar
    19 posts
    Member since:
    Jul 2012

    Posted 25 May 2015 in reply to Maya Link to this post

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

     

    Thanks for you support.

Back to Top
DevCraft banner