Updates to Gridweb databound to Custom Collection

Aspose.Cells Product Family
1

Hi,


I have a Gridweb which is databound to a Custom Collection of objects. I would like to know how can i update changed/new/deleted records back to the database. Ideally any new/deleted/changed records are updated back to the database when i click on the Default Save button at the bottom of the grid. Can you kindly help me solve my problem?

thanks and regards
Aaron
2

Hi,

Please check the demo for your reference:



Also, please check the article:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/binding-worksheet-to-a-customized-collection-object-using-gridweb.html

Thank you.

3

Hi,

I have already seen the documentation and there is no information on how to save changes back to the Database. Is there a way I can identify new/changed/deleted records?

thanks

4

Hi,

Well, we do support to bind the worksheet data with database, see the following links:


http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/binding-worksheet-to-a-dataset-at-run-time-using-gridweb.html

But again, since you are binding with custom collection, so I think you need to write your own .NET code to save/update records into database.

Thank you.