Saving dataset changes with TableAdapter.Update(DataTable)
I have a dataset that fills a tableadapter and I'd like to be able to post changes made to the dataset to a database with a date marking the changes. I've never used the TableAdapter.Update method before and was wondering if someone has any good tutorial links for that method.
Here is the code:
Public Class ExceptionEdit
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.
Private Sub SaveExceptionButton(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles saveexceptionsButton.Click
Catch ex As Exception
is it possible to update another database and not the scratchpad3 (since that's a temporary table and the actual table I need to update is a table called "Exceptions")
Last edited by dougancil; May 24th, 2011 at 03:39 PM.
Reason: didn't have code