Solved

autonumbering with update command

Posted on 2004-09-04
2
189 Views
Last Modified: 2010-04-15
I made an application that uses datasets to edit/insert/delete data from an Access database and then use the update command to update the database. In my database the id field of my table is an autonumbering field. When I add a row to my dataset, fill it, and use the update command to insert it in my database, I need to somehow retrieve the id field value that my database set during the insert command and put it in my dataset. Is that possible?

Thank you.

.arj
0
Comment
Question by:dotarj
2 Comments
 

Author Comment

by:dotarj
ID: 11979698
I found the solution here:

http://www.codeproject.com/cs/database/relationaladonet.asp

I will ask a moderator to close the question.

Bye.

.arj
0
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 11979793
Closed, 75 points refunded.
CetusMOD
Community Support Moderator
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This video discusses moving either the default database or any database to a new volume.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now