Saving updates to a datatable to database

[dougancil]

I have a form in my application that presents users with a datagridview which pulls data from database-a. I then offer the users the ability to edit that data but what I'd like to do is when they click the save event, that it saves their changes to database-b. Can this be done?

Thank you

Doug

[mreed72]

Create a connection to the second database, and then have the tablemanager update the table for the second database instead of the first:

instead of:

Me.TableAdapterManager.UpdateAll(Me.Database1DataSet)

Use:

Me.TableAdapterManager.UpdateAll(me.Databse2Dataset)

[dougancil]

Mreed,

here's the code I have thus far:

    Private Sub ExceptionEdit_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'MDRDataSet.scratchpad3' table. You can move, or remove it, as needed.
        Me.Scratchpad3TableAdapter.Fill(Me.MDRDataSet.scratchpad3)
        Exceptioncopy()
    End Sub
    Private Sub SaveExceptionButton(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles saveexceptionsButton.Click
        Dim oCmd2 As System.Data.SqlClient.SqlCommand
        oCmd2 = New System.Data.SqlClient.SqlCommand
        Try
            With oCmd2
                .Connection = New System.Data.SqlClient.SqlConnection("Initial Catalog=mdr;Data Source=xxxxx;uid=xxxxx;password=xxxxx")
                .Connection.Open()
                Me.TableAdapterManager.UpdateAll()
                MsgBox("Update successful")
            End With
        Catch ex As Exception
            MsgBox("Update failed")
        End Try
    End Sub
 

and I tried to add the me.tableadaptermanager code to this form and intellisense is telling me that tableadaptermanager is not part of my form.