private void btn_OK_Click(object sender, EventArgs e) { if (rb_Sql.Checked) { // if the address field is blank, dont do anything and alert the user if (tb_address.Text == "") { MessageBox.Show("No Address Specified. Specify an address."); this.DialogResult = DialogResult.None; return; } // if the database field is blank, dont do anything and alert the user if (tb_database.Text == "") { MessageBox.Show("No Database Specified. Specify a Database."); this.DialogResult = DialogResult.None; return; } // if the timeout field is blank, dont do anything and alert the user if (tb_timeout.Text == "") { MessageBox.Show("No Timeout Specified. Specify a Timeout value."); this.DialogResult = DialogResult.None; return; } } else { if (tb_ConnectionString.Text == "") { MessageBox.Show("No Connection String Specified. Specify a connection string."); this.DialogResult = DialogResult.None; return; } } try { String error; bool bSuccess = false; if (rb_Sql.Checked) { using (ADOConnection Conn = new ADOConnection(null, tb_address.Text, tb_database.Text, tb_username.Text, tb_password.Text)) { bSuccess = Conn.TestConnection(out error); if (bSuccess) { m_ConnectionString = Conn.ConnectionString; } } } else { using (ADOConnection Conn = new ADOConnection(tb_ConnectionString.Text)) { bSuccess = Conn.TestConnection(out error); if (bSuccess) { m_ConnectionString = tb_ConnectionString.Text; } } } if (!bSuccess) { this.DialogResult = DialogResult.None; MessageBox.Show(error); } } catch (Exception ex) { MessageBox.Show(ex.Message); this.DialogResult = DialogResult.None; return; } }
private void btn_testconn_Click(object sender, EventArgs e) { this.DialogResult = DialogResult.None; if (rb_Sql.Checked) { if (tb_address.Text == "") { MessageBox.Show("No Address Specified. Specify an address."); return; } if (tb_database.Text == "") { MessageBox.Show("No Database Specified. Specify a Database."); return; } if (tb_timeout.Text == "") { MessageBox.Show("No Timeout Specified. Specify a Timeout value."); return; } } else { if (tb_ConnectionString.Text == "") { MessageBox.Show("No Connection String Specified. Specify a connection string."); return; } } try { string error; if (rb_Sql.Checked) { using (ADOConnection Conn = new ADOConnection(null, tb_address.Text, tb_database.Text, tb_username.Text, tb_password.Text)) { if (Conn.TestConnection(out error)) { MessageBox.Show("Connection to " + tb_address.Text + "\\" + tb_database.Text + " was successful."); } else { MessageBox.Show("Connection to " + tb_address.Text + "\\" + tb_database.Text + " failed. " + error); } } } else { using (ADOConnection Conn = new ADOConnection(tb_ConnectionString.Text)) { if (Conn.TestConnection(out error)) { MessageBox.Show("Connection to " + tb_ConnectionString.Text + " was successful."); } else { MessageBox.Show("Connection to " + tb_ConnectionString.Text + " failed. " + error); } } } } catch (Exception ex) { MessageBox.Show("Error in ConnectionDialog.TestConnection." + ex.Message); return; } }