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
0
Josh
Top achievements
Rank 1
answered on 29 Aug 2016, 05:59 AM
Can anyone speak to if this is possible?
0
Accepted
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
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
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
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.