I have an Invoice program which I am working on. I want to know how to create an entry into another database after it saves the invoice to log the payment details in a seperate database. I have enclosed my code, no errors on debug, but no entries into the close-out database either.

Code:
Me.Validate()
        Me.InvoicesBindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me.CloseoutsDataSet)
        MessageBox.Show("Account Updated")
        Me.TotalAmountTextBox.Text = SubtotalTextBox.Text
        Me.TransactionAmountTextBox.Text = GrandTotalTextBox.Text
        Me.PaymentTypeTextBox.Text = PaymentTypeComboBox.Text
        Me.TransactionNoTextBox.Text = InvoiceNoTextBox.Text
        Me.CloseoutsBindingSource.EndEdit()
        Me.CloseoutsTableAdapter.Update(CloseoutsDataSet.Closeouts)
What in the world am I doing wrong? As you can see, I am updating two databases. One stores the details of the Invoice and the other logs the payments for Cashier Close-outs.

Thanks in advance!