Comparing values in collections

[Bezzie]

This is probably a stupid question but got some writers block or something.

Got two collections:
colPrices has share prices and the key of the collection is a share code.
colShares has a number of shares held and the key of the collection is also the share code.

The two collections might not be in the same order (although they probable will be) but they will have the same number of elements. So each share code will be in each collection.

Want to iterate through the Prices collection and find any entries with a 0 price then look in the Shares collection if there is a value > 0 there for the same share. How do I get the value of the key from one collection so I can use it to look in the other collection for the same key (code)?

[Kyle123]

You can't, it's not possible to retrieve the keys of a collection, for that you need to use a dictionary object. Having said that, wouldn't it just be easier to have a single collection with each element having 2 properties, number of shares and value? That way, you would only need a single iteration

[Bezzie]

How do you get more values for each key in a collection? I thought you can only have one value with each key.

[Kyle123]

You can, but that value doesn't have to be just a number or a string, it could be an array or a class for example. Consider:

Please Login or Register  to view this content.

[Bezzie]

Problem solved with a third collection with only the share codes. Then used this collection to iterate and compare the values in the other two collections.

Please Login or Register  to view this content.

And it doesn't matter in what order any of the collections are. It uses the right one.