Solved

autonumbering with update command

Posted on 2004-09-04
2
191 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: Ivo
C# And Nullable Types Since 2.0 C# has Nullable(T) Generic Structure. The idea behind is to allow value type objects to have null values just like reference types have. This concerns scenarios where not all data sources have values (like a databa…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

776 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