SqlCommandでReturnValueを取得
using (SqlCommand cmd = cn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = @"upGetColor"; cmd.Parameters.Add("@name", SqlDbType.NvarChar).Value = "Red"; cmd.Parameters.Add("@code", SqlDbType.NvarChar).Direction = ParameterDirection.ReturnValue; cmd.ExecuteNonQuery(); string strColorCode = cmd.Parameters["@code"].Value.ToString(); }