how to get an OutPut parameter value of a stored procedure?

[cloudx]

Hi there,

I would like to call a stored procedure with an OutPut parameter and then
get the value of the OutPut in C#, here is my code, I expect it displays 1
for @MyOutPutInt but nothing actually displayed.
....
CDatabase oDatabase = new CDatabase(sConnectionString);
try
{
oDatabase.Open();
CParameterCollection colParameters = new CParameterCollection();
colParameters.AddOutputParameterInt("@MyOutPutInt" );
oDatabase.ExecuteSP("sp_MySP", colParameters);
Console.WriteLine("@MyOutPutInt = {0}",
colParameters["@MyOutPutInt"].value);
}
catch
{
Console.WriteLine("something wrong!");
}
finally
{
oDatabase.Close();
}

the sp_MySP is something like below:

create sp_MySP
@MyOutPutInt int output
as
set @MyOutPutInt = 1
return
go

Thanks!