6 Answers, 1 is accepted
Can anyone speak to if this is possible?
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:
Telerik by Progress
[quote]Josh said:Thank you Nencho[/quote]
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.
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 ?
For the WinForms RadSpreadsheet, one possible approach is to inherit the RadSpreadsheetRibbonBar class and override backstageButtonSave_Click.