Output parameter

[Guest]

Hi,

I have a stored procedure with an output parameter.

SqlCommand cmd = new SqlCommnad("ProcName", conn);
cmd.Parameters.Add("@myparam", SqlDbType.Int);
cmd.Parameters[0].Direction = ParameterDirection.Output;

Parameter param is an output parameter, but how can I read the returned value?

Thanks,

Lubomir

 

[Charles Zhang]

After you execute the command, you can access the value using
cmd.Parameters[0].value in your example.

If you are using ExecuteReader, you need to close the reader object
before accessing the output parameter.

Charles Zhang
http://www.speedydb.com
SpeedyDB ADO.NET Provider is the fastest ADO.NET provider over Wide Area
Network (WAN).

 

[Guest]

Thank you!

Lubomir

After you execute the command, you can access the value using
cmd.Parameters[0].value in your example.

If you are using ExecuteReader, you need to close the reader object
before accessing the output parameter.

Charles Zhang
http://www.speedydb.com
SpeedyDB ADO.NET Provider is the fastest ADO.NET provider over Wide Area
Network (WAN).

Hi,

I have a stored procedure with an output parameter.

SqlCommand cmd = new SqlCommnad("ProcName", conn);
cmd.Parameters.Add("@myparam", SqlDbType.Int);
cmd.Parameters[0].Direction = ParameterDirection.Output;

Parameter param is an output parameter, but how can I read the returned value?

Thanks,

Lubomir