Here is the SP i am using

--------------------------------------------

CREATE PROCEDURE dbo.sp_AddUpdateEmpTable

@EmpName nvarchar(50),

@EmpID int,

@returnEmpID int output

AS

BEGIN

If exists(select * from EmpTable where EmpID= @EmpID)

BEGIN

Update EmpTable

Set EmpName=@EmpName

Where EmpID = @EmpID

select @returnEmpID= @EmpID

END

Else

BEGIN

Insert into...

i am using the command object....& doing what u suggested

after i execute the SP thro the command.execute method....& check for the number of recs affected...it shows properly....but this method is...