jQuery UI Widgets Forums Grid Copying large amount of rows

Tagged: , , ,

This topic contains 1 reply, has 2 voices, and was last updated by  ivailo 8 years, 9 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • Copying large amount of rows #75919

    MrWinky
    Participant

    I have a grid thats starts with 5000 blank rows. When the users start copying many rows of data into the grid from Excel, the grid gets an addrow event per column, per line. Instead of making the user click a “Save” button, our addrow event is designed to insert or update the row into the backend (we use an Ajax call to .net WEBAPI).

    In my case, I don’t know if one row is added or 2000. And there are 18 columns.

    The problem occurs when there is a large amount of rows like that. Each and every row with it’s columns that was copied generates it’s own addrow event (instead of one call with an array of all the data copied). Therefore, the Ajax async events to update the database start falling behind and so the database may be missing some random rows or a random column data here and there. Debugging through the browser, I can see its because the backend webapi calls get overloaded and some updates don’t go through.

    Is there a way to overcome this without resorting to a “Save” button routine. For example, is there a way I can get the one event call with all the data to be copied has been pasted?

    Copying large amount of rows #75928

    ivailo
    Participant

    MrWinky

    Unfortunately there is not another option to solve the problem.

    Best Regards,
    Ivailo Ivanov

    jQWidgets Team
    http://www.jqwidgets.com

    • This reply was modified 8 years, 9 months ago by  ivailo.
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.