string
connStr = “server=kofo;database=pubs;uid=sa;pwd=kofo123”;
SqlConnection myConnection =
new
SqlConnection(connStr);
try
{
myConnection.Open();
SqlCommand myCommand =
new
SqlCommand(“TestRetValue”,myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter myParam = myCommand.Parameters.Add(
new
SqlParameter(“@RETURN_VALUE”,SqlDbType.Int,4));
myParam.Direction = ParameterDirection.ReturnValue;
myCommand.ExecuteNonQuery();
int
me = (
int
)myParam.Value;
MessageBox.Show(me.ToString());
}
catch
(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
myConnection.Close();
}