private void button1_Click(object sender, EventArgs e) { // getting the values from from String username = usernameRegister.Text; String password = passwordRegister.Text; String email = emailRegister.Text; String confirm = confirmPassword.Text; // adding a new user dataBase db = new dataBase(); MySqlCommand command = new MySqlCommand("INSERT INTO `registration`(`Username`, `Email`, `Password`, `ActiveStatus`) VALUES (@user, @mail, @pass, @active)", db.getConnection()); command.Parameters.Add("@user", MySqlDbType.VarChar).Value = username; command.Parameters.Add("@mail", MySqlDbType.VarChar).Value = email; command.Parameters.Add("@pass", MySqlDbType.Text).Value = password; command.Parameters.Add("@active", MySqlDbType.Int32).Value = 1; if (!(username == "Username" || password == "Password" || email == "Email")) { if (password == confirm) { if (!check()) { // connection open db.openConnection(); // execute command if (command.ExecuteNonQuery() == 1) { this.Hide(); mainPage mp = new mainPage(); mp.ShowDialog(); this.Close(); } else { MessageBox.Show("Error"); } // close connection db.closeConnection(); } else { MessageBox.Show("Username Already Taken!", "Duplicate user", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Passwords does not match!"); } } else { MessageBox.Show("Enter Valid values!"); } }
private void LoginButton_Click(object sender, EventArgs e) { dataBase db = new dataBase(); String username = Username.Text; String password = Password.Text; DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("SELECT * FROM `registration` WHERE `Username` = @user and `Password` = @pass", db.getConnection()); command.Parameters.Add("@user", MySqlDbType.VarChar).Value = username; command.Parameters.Add("@pass", MySqlDbType.Text).Value = password; adapter.SelectCommand = command; adapter.Fill(table); // check if username exists or not if (table.Rows.Count > 0) { this.Hide(); mainPage mp = new mainPage(); mp.ShowDialog(); this.Close(); } else { if (username.Trim().Equals("")) { MessageBox.Show("Enter Username to Continue!", "Empty Username"); } else if (password.Trim().Equals("")) { MessageBox.Show("Enter Password to Continue!", "Empty Password"); } else { MessageBox.Show("Wrong Username or Password!", "No User Found"); } } }