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

AlHussain Bin Talal University