private void btlogin_Click(object sender, EventArgs e) { /* frmHome home = new frmHome(); * home.Show(); * this.Hide(); */ //conexão banco OracleConnection conexao = new OracleConnection(@"Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost) (PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = xe)));Password=1234567;User ID= hotelsystem"); try { conexao.Open(); //abrir banco OracleCommand command = new OracleCommand(@"select * from usuario where usuario =:usuario and senha_user = :senha_user", conexao); command.Parameters.Add(":usuario", txtloginlog.Text); command.Parameters.Add(":senha_user", txtsenhalog.Text); command.ExecuteNonQuery(); //ler o resultado OracleDataReader drms = command.ExecuteReader(); //roda resultado if (drms.HasRows == false) //se as informações estiverem erradas, exibir mensagem de erro { throw new Exception("Usuário ou senha inválidos!"); } drms.Read(); //informações correta abrir form home MessageBox.Show("Login efetuado com sucesso!"); frmHome home = new frmHome(); home.Show(); this.Hide(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conexao.Close(); } }
private void btNao_Click(object sender, EventArgs e) { frmHome home = new frmHome(); home.Show(); }