Getting the value of the primary key after INSERT

[Timothy]

Hello,

I know there's a way to get the primary key of the record you just
inserted into the database with @ID or something, but I don't remember
exactly how.

Using MSAccess & C#

Thnx.

 

[Miha Markic]

Hi Timothy,

You are looking for:
HOW TO: Retrieve the Identity Value While Inserting Records into Access
Database By Using Visual C# .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;816112&Product=vcSnet

 

[Paul Clement]

¤ Hello,
¤
¤ I know there's a way to get the primary key of the record you just
¤ inserted into the database with @ID or something, but I don't remember
¤ exactly how.
¤
¤ Using MSAccess & C#

If you are using a Jet 4.0 database (2000 or higher) see the following:

http://msdn.microsoft.com/library/d...cpconRetrievingIdentityOrAutonumberValues.asp


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Timothy]

¤ Hello,
¤
¤ I know there's a way to get the primary key of the record you just
¤ inserted into the database with @ID or something, but I don't remember
¤ exactly how.
¤
¤ Using MSAccess & C#

If you are using a Jet 4.0 database (2000 or higher) see the following:

http://msdn.microsoft.com/library/d...cpconRetrievingIdentityOrAutonumberValues.asp


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

Thank you both for your help, and also for helping with my compacting
problem