loop parameters collection and determine param type

[martin]

Hi,

I am writin a function to execute stored procedures.
The function gets passed an array with the values of the parameters and if
they are input out put params.
I attach these to the command onject no problem and execute the sp.

After execution I need to get back he values of the output parameters.
what I would like to do is
1. loop through the parameters collection.
2. determine whether the param is niput or output
3 determine the name of the parameter.
4. retrive the name of the parameter.
5. lastly retrieve the value of the parameter.

could any body please explain how I would go about doing steps 1 through 5
please.

many thanks in advance.

martin.