Cannot unbox as Int

Question

I have this sql parameter im getting the cant unbox as int error

returnValue = (int)cmdUpdateCreatedOn.Parameters["@intcount"].Value;

return value is declared as int returnValue = 0 and my parameter is also declared as int, and it is getting the rowcount of rows updated. I've tried different converting syntax none seem to work.

MY SP is

ALTER Procedure [dbo].[UpdateStation]
@intcount int output AS 
select StationaryName into #stname from Stationaries where Authorized = 0 
select * from #stname 
Update Stationaries Set  Authorized = 1 where Authorized = 0 set @intcount =   @@rowcount

Answer 1

I had the same issue.

The INT being returned in stored procedure is of type 'SHORT'. I do not know why.

Cannot cast ..."@SubjectID"... (which has an actual type of 'short') to 'string'.

Solution:
1. Unbox to 'SHORT' in c# OR
2. Use Convert.ToInt32 in c#.