CODEWITHSUNDEEP
c#.netdatabasems-accessprimary-key
Robert Deml
Robert Deml

Reputation: 12532

Get the Primary Key of a new Entry

I have a number of child tables that have a foreign key to a parent table.

How do I add an entry in the parent table and get the primary key of that entry, so that I can then enter rows in the child tables that point to the entry in the parent table?

I'm doing this in a MS Access Database from a C# application.

Upvotes: 6

Views: 984

Answers (4)

Instantsoup
Instantsoup

Reputation: 15265

Microsoft Access 2000 or later does support the @@IDENTITY property to retrieve the value of an Autonumber field after an INSERT. (msdn)

Edit: This is the link to a similar article for .NET 3.5

Upvotes: 5

Joe Phillips
Joe Phillips

Reputation: 51110

Try looking into the global variables that will give you the identity value. In SQL Server it is:

SELECT @@identity

Also look into the Scope_Identity() function

Upvotes: 3

Pavel Chuchuva
Pavel Chuchuva

Reputation: 22455

Getting the identity of the most recently added record

Upvotes: 4

devmode
devmode

Reputation: 3567

Should be able to SELECT @@IDENTITY even though you will have to use a second query to do so. I don't think MS Access will allow it to be combined into one query.

Upvotes: 1

Related Questions