This is a migrated thread and some comments may be shown as answers.

Save action override?

6 Answers 214 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Josh
Top achievements
Rank 1
Josh asked on 25 Aug 2016, 08:50 PM
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

6 Answers, 1 is accepted

Sort by
0
Josh
Top achievements
Rank 1
answered on 29 Aug 2016, 05:59 AM

Can anyone speak to if this is possible? 

0
Accepted
Nencho
Telerik team
answered on 30 Aug 2016, 07:09 AM
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.
0
Josh
Top achievements
Rank 1
answered on 30 Aug 2016, 05:13 PM
Thank you Nencho
0
Karthik
Top achievements
Rank 1
answered on 20 Oct 2017, 04:13 PM

[quote]Josh said:Thank you Nencho[/quote]

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. 

 

0
Mas
Top achievements
Rank 1
answered on 18 Oct 2018, 04:09 AM

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

 

0
Peter Milchev
Telerik team
answered on 22 Oct 2018, 09:23 AM
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.
Tags
Spreadsheet
Asked by
Josh
Top achievements
Rank 1
Answers by
Josh
Top achievements
Rank 1
Nencho
Telerik team
Karthik
Top achievements
Rank 1
Mas
Top achievements
Rank 1
Peter Milchev
Telerik team
Share this question
or