update Spreadsheet

Posted by: chintu on 8 September 2017, 1:13 pm EST

  • Posted 8 September 2017, 1:13 pm EST

    How  to update editable spread sheet in windows application .net 2005?
  • Replied 8 September 2017, 1:13 pm EST

    Could 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

    Hello,


    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 EST

    After 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 EST

    You 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
          Try
            oleDbDataAdapter1.Update(ds, "Customers")
            ds.AcceptChanges()
            fpSpread1.ActiveSheet.GetDataView(True)
          Catch
          End Try
        End Sub
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels