private void btnListarTabelas_Click(object sender, EventArgs e) { bool verifica = false; TiposDeBancoDeDados BD; ControlaInterface controlainterface = new ControlaInterface(); if (tbcBD.SelectedTab.Text == "SqlServer") { BD = TiposDeBancoDeDados.SQLSERVER; if (chkWindwsAuthentication.Checked) { if (cmbServeName.Text != string.Empty) { verifica = controlainterface.VerificaConexao(cmbServeName.Text, cmbDataBase.Text); } } else { if (cmbServeName.Text != string.Empty && txtLogin.Text != string.Empty && txtSenha.Text != string.Empty) { verifica = controlainterface.VerificaConexao(cmbServeName.Text, cmbDataBase.Text, txtLogin.Text, txtSenha.Text); } } } else { BD = TiposDeBancoDeDados.ORACLE; verifica = controlainterface.VerificaConexao(@"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + txtLocalHost.Text + ")(PORT=" + txtPorta.Text + ")))(CONNECT_DATA=(SERVICE_NAME=" + txtSID.Text + ")))", txtNomeUsuario.Text, txtSenhaOralce.Text, BD); } if (verifica) { controlainterface.ListaTabelas(chkTabelas, BD, true); } }
private void Nenhum_Click(object sender, EventArgs e) { bool verifica = false; ControlaInterface controlainterface = new ControlaInterface(); if (chkWindwsAuthentication.Checked) { if (cmbServeName.Text != string.Empty) { verifica = controlainterface.VerificaConexao(cmbServeName.Text, cmbDataBase.Text); } } else { if (cmbServeName.Text != string.Empty && txtLogin.Text != string.Empty && txtSenha.Text != string.Empty) { verifica = controlainterface.VerificaConexao(cmbServeName.Text, cmbDataBase.Text, txtLogin.Text, txtSenha.Text); } } if (verifica) { controlainterface.ListaTabelas(chkTabelas, TiposDeBancoDeDados.SQLSERVER, false); } }