[RESOLVED] how to get the autoIncrement field value ?

[ini_hendry]

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 ?