Save action override?

7 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. 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? 

  3. Answer
    Nencho
    Admin
    Nencho avatar
    1784 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.
  4. Josh
    Josh avatar
    3 posts
    Member since:
    Jul 2016

    Posted 30 Aug 2016 Link to this post

    Thank you Nencho
  5. 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. 

     

  6. Mas
    Mas avatar
    6 posts
    Member since:
    Sep 2018

    Posted 17 Oct 2018 in reply to Nencho Link to this post

    Hello Nencho,

    I can not find any example of CustomDatabaseProvider for Winform Radspreadsheet, all samples are refer to web version (asp, wpf).

    I know I can modify save command behavior on radrichtexteditor by listen to CommandExecuting event, but I can not find this event on radSpreadsheet class.

    So, is it possible to directly listen to save event (by tapping command executing event) and save the binary of entire workbook to my database ?

    Regards,

    mas Tri

     

  7. Peter Milchev
    Admin
    Peter Milchev avatar
    476 posts

    Posted 22 Oct 2018 Link to this post

    Hello Mas Tri,

    For the WinForms RadSpreadsheet, one possible approach is to inherit the RadSpreadsheetRibbonBar class and override backstageButtonSave_Click.

    Regards,
    Peter Milchev
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top