How to insert data from grid into database

Aspose.Cells Product Family
1

Hi


Is there any sample code that shows how to insert/copy all data from Aspose Grid into a database?

Thank You.
2

Hi,

I think you can use Data Binding feature provided by Aspose.Cells.GridWeb control, see some articles for your reference:
Implementing grid desktop data binding feature is worksheets

Also, see the demos:

Thank you.

3

Hi


The example shows how to load a web worksheet from dataset. But I want to make use of the “Save” button below the grid and when I click it, it will save my results into database.

I did search through the online documentation, but cant find any related.

Please advice.
4

Hi,

Well, I think you may use WebCells.Export() method to export your worksheet data to fill a datatable, later you may use .NET APIs to use your own code to save it to your datasource table.

See the WebCells.Export() method API Description.
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/aspose.cells.gridweb.data.webcells.export_overload_1.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/aspose.cells.gridweb.data.webcells.export_overload_2.html

Thank you.