Hello friends!

i am using a store procedure to update multiple records using the next SP code :
this is because i am lock masive updates via the trigger update...

declare @idPrestamo2 int, @idDocumento2 int 
Declare C_PRESTAMOS cursor for
      select idPrestamo,idDocumento from XSARCPrestamos           
            where idPrestamo = @idPrestamo
      ----------------------------------------------------
      Open C_PRESTAMOS    
      FETCH C_PRESTAMOS into @idPrestamo2,@idDocumento2      
      WHILE @@FETCH_STATUS = 0	
        Begin
            ---------------------------------------------------------------------
			BEGIN TRANSACTION
            UPDATE XSARCPrestamos
			SET idEstadoPrestamo=@idNuevoEstado				
				WHERE idPrestamo  = @idPrestamo2
				  and idDocumento = @idDocumento2
            --------------------------------------------------------------------
            if @@error<>0 --error
            begin
		        ROLLBACK TRAN
				RAISERROR('stp_xsarcprestamos_UPDATEIdEstado-Error al actualizar el Estado del prestamo.',14,1)
				RETURN 0
             end
		     else
			 begin	
				select @AffectedRows=@@ROWCOUNT							
				COMMIT
				FETCH C_PRESTAMOS into @idPrestamo2,@idDocumento2
			 end			 
       End
DEALLOCATE C_PRESTAMOS
...
...

so, i am using the next c# code to run the storeprocedure...

//the number of affected rows.
        int affectedRows = -1;

        //execute the command making sure the connection gets closed in the end.
        try
        {
            //open the connecction of the command
            command.Connection.Open();

            //execute the command and get the number of affected rows.
            affectedRows = command.ExecuteNonQuery();            
        }
        catch (Exception ex)
        {}

but ever the affectedRows var return -1 and the records don't updated.....

i run the SP in the serve and work fine....whats is grong?, any help is grear appreciated...