Q

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 last published in December 2004

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchCloudComputing

SearchSoftwareQuality

SearchSOA

TheServerSide

SearchCloudApplications

Close