Save action override?

[Josh]

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

[Josh]

Can anyone speak to if this is possible? 

[Nencho]

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

[Josh]

Thank you Nencho

[Karthik]

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

 

[Mas]

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

 

[Peter Milchev]

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