How to get @@Identity value using ADO.NET and ASP.NET

[Dsquare]

CREATE PROCEDURE sp_InsertMaterial

@MatEngName nvarchar(100),@MatJapName nvarchar(500),@Comments
nvarchar(500),@ImagePath nvarchar(100),@ImageStatus
nvarchar(50),@AddedDate datetime

AS

INSERT INTO
MaterialMaster(MaterialEngName,MaterialJapName,Comments,ImagePath,ImageStatus,AddedDate)

VALUES(@MatEngName,@MatJapName,@Comments,@ImagePath,@ImageStatus,@AddedDate)

SELECT @@IDENTITY as 'Identity'

This is my stored procedure to insert records in a particular table,
using Ado.net i want to retrieve this Identity number....

Can any body help..

 

[Christopher Reed]

Use an output parameter from your stored procedure and capture it as a
parameter in your code.

 

[Karl Seguin]

Agree with the answer given, but thought I'd mention that you should be
using SCOPE_IDENTITY() instead of @@IDENTITY...you can learn more as to why
here:
http://weblogs.asp.net/rosherove/archive/2003/11/13/37217.aspx

Karl

 

[Dsquare]

Thank you very much....