Store Pro & out Parameters

[dnanetwork]

i can handle a store procedure which returns one output parameter using ExecuteScalar()

but wot if my store procedure returns more than one parameter
then how can i handle it. any advice Adapost ?

[rohand]

i think by following below code, we can retrieve value of more than one parameter. The code is for one parameter.

SqlParameter returnValueParam = cmd.Parameters.Add(@return,SqldbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
int returnValue = (int) returnValueParam.Value;

[dnanetwork]

thnx rohand...i'll check and let u know...