ADO » Parameters » Count
The Count property returns a long value that is the number of items in the collection. The counting starts at zero. You can use this value to loop through the collection by iterating from zero to the value of Count minus one.
Examples
Code:
intCountNumber = objCommand.Parameters.Count
Code:
For Each objParameter In objCommand.Parameters
' place code here to manipulate each item in collection
Next
Output:
You can also use the VB/VBScript For Each ... Next statement.