ExecuteScalar requires an open and available Connection. The connection's current state is closed.ExecuteScalar requires an open and available Connection. The connection's current state is closed.ExecuteScalar requires an open and available Connection. The connection's current state is closed. Jordan Aviation ExecuteScalar requires an open and available Connection. The connection's current state is closed.