public bool IsConnectionValid() { string connectionString = String.Format("Data source= {0}; Initial catalog= {1}; UID= {2}; Password= {3};", ServerName, DatabaseName, LoginDB, PasswordDB); var connection = new SqlConnection(connectionString); try { connection.QuickOpen(SqlConnectionConstants.OpenTimeout); connection.Close(); return true; } catch (Exception e) { return false; } }
public bool TestIps() { connectionStringBuilder.DataSource = this.Ip1; try { using (var conn = new SqlConnection(connectionStringBuilder.ToString())) { conn.QuickOpen(1000); return true; } } catch { connectionStringBuilder.DataSource = this.Ip2; try { using (var conn = new SqlConnection(connectionStringBuilder.ToString())) { conn.QuickOpen(1000); return true; } } catch { return false; } } }