private void cbDatabase_DropDown(object sender, System.EventArgs e) { if (sqlConnection.State == System.Data.ConnectionState.Closed) { sqlConnection.Schema = "public"; sqlConnection.Open(); } cbDatabase.Items.Clear(); DataTable databases = sqlConnection.GetSchema("Databases"); foreach (DataRow row in databases.Rows) { cbDatabase.Items.Add(row[0]); } }
private void btTest_Click(object sender, System.EventArgs e) { try { FillConnectionString(); connection.Open(); lbState.Text = "Success"; lbState.ForeColor = Color.Blue; connection.Close(); } catch (Exception exception) { lbState.Text = "Failed"; lbState.ForeColor = Color.Red; lbError.Text = exception.Message; } }