Saving spreadsheet data to SQL table or DataTable

[Travis Chambers]

Good day,

I am loading a spreadsheet control with data from SQL successfully with a simple "Select" query to DataTable, and then setting the Dt as the DataSource for the spreadsheet.

I need to be able to edit the data in the spreadsheet and then save it back to the SQL table, or at least to a datatable, but I can not figure out how to do this.

I am used to using the Spreadsheet (and GridControl) components in WinForms where I loop through the records to convert the data, but in Asp.net there does not appear to be any way to access the range or individual cell values.

Any help would be much appreciated.

thanks!

[Gayathri KarunaiAnandam]

Hi Travis, 

We have checked your reported query. Before proceed further, we would like to know the following details. 

• Could you please share your platform?
• Could you please confirm whether you use EJ2 or EJ1 Spreadsheet?
• Please share the Syncfusion version you are using.

 

Could you please get back to us with the above information, so that we can analyze based on that and provide you a better solution?  The information provided would be great help for us to proceed further. 

We suggest that we have a knowledge base explain about how to save and retrieve Spreadsheet Data from SQL table. Please look into the KB for more information. 

KB: https://www.syncfusion.com/kb/12575/how-to-load-and-save-a-sql-table-in-spreadsheet-using-cellsave-event 

Regards, 

Gayathri K 

[Travis Chambers]

It is:

Asp.Net WebForm

EJ1 Spreadsheet

v19.2460.0.44

Thanks!

[Gayathri KarunaiAnandam]

Hi Travis, 

We have checked your reported query. We can load the data from the database to the Spreadsheet, please refer the below knowledge base link for how to load and save changes to a SQL table in EJ1 Spreadsheet. 

 

Please check the below link. 

 

KB: https://www.syncfusion.com/kb/8637/how-to-load-and-save-a-sql-table-in-spreadsheet 

Please check the above knowledge base and get back to us, if you need further assistance. 

Regards, 

Gayathri K 

[will]

Import and Export Wizard

In SQL Server Management Studio, connect to an instance of the SQL Server Database Engine.

Expand Databases.

Right-click a database.

Point to Tasks.

Choose to Import Data or Export Data:

Regards,

Will

[Vasanth Ravi]

Hi Will,

As suggested earlier please check with the below attached link to load sql to the spreadsheet.

https://www.syncfusion.com/kb/12575/how-to-load-and-save-a-sql-table-in-spreadsheet-using-cellsave-event

If we misunderstood your mentioned query / issue please provide the below requested details to proceed further.

1. Provide detailed video demonstration of the issue you were facing at your end.
   
   

2. Share any screenshots and images regarding your reported issue.

3. Share the detailed information on the issue you were facing and the steps to replicate it.