Get the Primary Key of a new Entry

By : Robert

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.

By : Robert


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

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

This video can help you solving your question :)
By: admin