Updating a dataadapter

[mfleet1973]

Hi Gang.

I'm using VB.Net 2003. In the following code I'm updating the
dataadapter with a new record added to the table:

OleDbDataAdapter1.Update(DataSet11.GetChanges, "Table")

However, when I add another record and update the dataadapter again,
the first record gets added a second time. Is there something else
that needs to be done after doing the update?

Thanks a lot!!

Mike.

[Steven Nagy]

Rather than calling DataSet11.GetChanges, just call the Dataset.
Ie:

OleDbDataAdapter1.Update(DataSet11, "Table")

Alternatively you can keep your existing code and call:
DataSet11.AcceptChanges()
after the line of code specified below.

mf********@yahoo.ca wrote:

Hi Gang.

I'm using VB.Net 2003. In the following code I'm updating the
dataadapter with a new record added to the table:

OleDbDataAdapter1.Update(DataSet11.GetChanges, "Table")

However, when I add another record and update the dataadapter again,
the first record gets added a second time. Is there something else
that needs to be done after doing the update?

Thanks a lot!!

Mike.

[Cor Ligthert [MVP]]

MFleet,

In addition to Steven, this behaviour is because the getchanges creates a
copy dataset.

Cor

<mf********@yahoo.ca> schreef in bericht
news:11*********************@p79g2000cwp.googlegro ups.com...

Hi Gang.

I'm using VB.Net 2003. In the following code I'm updating the
dataadapter with a new record added to the table:

OleDbDataAdapter1.Update(DataSet11.GetChanges, "Table")

However, when I add another record and update the dataadapter again,
the first record gets added a second time. Is there something else
that needs to be done after doing the update?

Thanks a lot!!

Mike.