Posted 8 September 2017, 1:13 pm ESTHow to update editable spread sheet in windows application .net 2005?
Posted by: chintu on 8 September 2017, 1:13 pm EST
Replied 8 September 2017, 1:13 pm ESTCould you be more specific as to what it is you are wanting to do. Are you bound or unbound, etc? What is it you are trying to update?
Replied 8 September 2017, 1:13 pm EST
In addition to what Bob asked, I would suggest downloading and watching our Training Videos on Getting Started with Spread for Windows Forms.
Replied 8 September 2017, 1:13 pm ESTAfter editing the spread sheet data i want to save spread sheet data into database in one click event.
Replied 8 September 2017, 1:13 pm ESTYou can do the following in a button click...
Private Sub button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles button1.Click
'Get the data from Spread
Dim ds As System.Data.DataSet
ds = CType(fpSpread1.Sheets(0).DataSource, System.Data.DataSet)
'Save the changes back to the database