Ask the Expert

Last record in the dataset is the only one updating to the database

I do not know if I understand the Data Adaptor correctly. I can populate a dataset with rows and then call the update method of the adaptor. My issue is the last record in the dataset is the only one that updates the to database. I am using an Access Database. Any ideas?
Using the Access Database is probably not the issue. I suspect you are telling the data table to "AcceptChanges" which will reset the row state so the data adapter doesn't know to send changes to the database.

This was first published in December 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: