Save action override?

5 posts, 1 answers
  1. Josh
    Josh avatar
    3 posts
    Member since:
    Jul 2016

    Posted 25 Aug 2016 Link to this post

    I am programmatically binding a RadSpreadsheet to a data table based on an SQL table. Is there a way to when the save button is clicked to override the default behavior and save the results of the modified data to a data table so that I can commit it back to my SQL database? Any help is appreciated
  2.
  3. Josh
    Josh avatar
    3 posts
    Member since:
    Jul 2016

    Posted 29 Aug 2016 Link to this post

    Can anyone speak to if this is possible? 

  5. Answer
    Nencho
    Admin
    Nencho avatar
    1749 posts

    Posted 30 Aug 2016 Link to this post

    Hello Josh,

    For that purpose, you need to implement a custom provider, where you can overwrite the SaveWorkbook method. At this point, you will be able to iterate through the cells and store the values in a preferable manner (SQL DataBase)

    Please refer to the following documentation article, providing more information on the matter, and note the linked code library:

    http://docs.telerik.com/devtools/aspnet-ajax/controls/spreadsheet/data-binding/providers/custom-database-provider

    Regards,
    Nencho
    Telerik by Progress
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
  7. Josh
    Josh avatar
    3 posts
    Member since:
    Jul 2016

    Posted 30 Aug 2016 Link to this post

    Thank you Nencho
  8.
  9. Karthik
    Karthik avatar
    10 posts
    Member since:
    Nov 2011

    Posted 20 Oct 2017 in reply to Josh Link to this post

    Josh said:Thank you Nencho

    Hi Josh,

    Were you able to achieve this? I am also looking for similar solution like yours. I want to update only the modified cells in the database. 

     

Back to Top