[RESOLVED] how to get the autoIncrement field value ?

i'm using .net 2.0 framework, c# language.

i got a table with a column set to be identity (auto increment by 1 every time i enter a row of data)

the details :
rid (int) : the primary key with auto increment 1
inTime(date)
outTime(date)

my insert query : "INSERT INTO [aTable] VALUES ('1984/3/3' , '1984/3/3')"
now..
is it possible, after i insert the data, i directly get a return of the 'rid' which is set to be auto incremented ?

The syntax is VB.Net, but it should be a simple conversion (ADO.Net is really persistent between VB and C#).
http://www.vbforums.com/showthread.php?t=379394

If you need help switching it over or have probs; let me know.

ouw..
awesome..
thx for da code..
it solve my problem directly