C# .NET - After inserting a record into database I need the currently inserted record Id

insert into emp(Name,Dept) values("ABC","AAA");
select Max(Id) from emp;


Here emp is table name and Id is autonumber.
I am using Msaccess Database

Try:

SELECT CONVERT(int, SCOPE_IDENTITY())