• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

autonumbering with update command

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
dotarj
Asked:
dotarj
1 Solution
 
dotarjAuthor Commented:
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
 
CetusMODCommented:
Closed, 75 points refunded.
CetusMOD
Community Support Moderator
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now