How To Fetch Value That Is Returened By Stored Prosedure ???...

I am inserting value in the database with identity column, but I want to know the identity column value that is inserted by this command. I don't want to use any additional query to fetch this value, so I have created a stored Prosedure that Inserts value with identity column in the database and also returns last identity column value.

But i don't know how to fetch this value in ASP.Net, because ExecuteNonQuery() is used for INSERT,UPDATE and DELETE only, bu using this method my half of need will be completed (that is insertion) but how i fetch returned value.

I am putting table and Stored Prosedure, pls reply me how i get returned value.

 --following is my emp table
create table emp
(
EID int identity(1,1),
EName varchar(50)
)
--following is my stored prosedure

create proc ReturnID @ename varchar(50)
as
insert into emp values(@ename)
begin tran
declare @err int
set @err = @@ERROR
if @err <> 0
return select max(eid) from emp
commit tran


--following command insert value in database and returns last ID
ReturnID jasim


 

Pls reply me with proper solutions.