save data back to database table

[Edward Pauley]

Hi

how will i be able to save the data on the spreadsheet back to database tables (such as customer, order,...) as the radgridview normally does?

and input the spreadsheet source a collection of data retrieving from database


Note:  i know that we can save the whole spreadsheet data as a binary stream and save it back to database (this is the only way to save data to database ?)


thanks

[Andrew]

Hello Edward,

The only way to persist the data from RadSpreadsheet is, as you said, to save it as a binary stream. If you want to bind to different tables in the database, you may try using our RadGridView. For the time being RadSpreadsheet does not support external data-sources which you can bind to. In the future we would definitely consider adding this functionality, but we do not have a specific time frame which we can commit to.

All the best,
Andrew
the Telerik team