private void button1_Click(object sender, EventArgs e) { if (textBox2.Text == textBox3.Text) { OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "insert into Users values (:us , :ps , :st) "; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("us", textBox1.Text); cmd.Parameters.Add("ps", textBox2.Text); cmd.Parameters.Add("st", "u"); int r = cmd.ExecuteNonQuery(); if (r != -1) { this.Hide(); ViewFlight v = new ViewFlight(textBox1.Text); v.ShowDialog(); } } else { MessageBox.Show("invalid password "); textBox2.Clear(); textBox3.Clear(); } }
private void button1_Click(object sender, EventArgs e) { OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "select status from Users where UserName =:us and Pword = :ps "; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("us", textBox1.Text); cmd.Parameters.Add("ps", textBox2.Text); OracleDataReader dr = cmd.ExecuteReader(); int counter = 0; while (dr.Read()) { counter++; stat = dr[0].ToString(); } dr.Close(); if (counter == 1 && stat == "u") { this.Hide(); ViewFlight v = new ViewFlight(textBox1.Text); v.ShowDialog(); } else if (counter == 1 && stat == "a") { this.Hide(); Admin a = new Admin(); a.ShowDialog(); } else if (counter == 0) { MessageBox.Show("wrong username or password"); textBox1.Clear(); textBox2.Clear(); } }