ParameterName ="@TotalStudents", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output,// direction output } Once the stored procedure is executed we can get the value returned by the output parameter like this: ...