private void checkOpen() { if (theConn.State != System.Data.ConnectionState.Open) { theConn.Open(); } }