private void button1_Click_1(object sender, EventArgs e) { SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = " select * from library_person where username='******' and password='******'"; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); count = Convert.ToInt32(dt.Rows.Count.ToString()); if (count == 0) { MessageBox.Show("Wrong Username/Password !!!\nPlease Try Again"); } else { this.Hide(); mdi_user mu = new mdi_user(); mu.Show(); } }
private void button1_Click(object sender, EventArgs e) { string sql = $"select * from library_person where username='******' and password='******';"; //takes the data from the password and user fields and checks them agains the database MySqlCommand cmd = new MySqlCommand(sql, dbconnection); cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); // creating a datatable to populate with the users' credentials provided MySqlDataAdapter da = new MySqlDataAdapter(cmd); //uses a data adatapter and fills the newly created datatable da.Fill(dt); count = Convert.ToInt32(dt.Rows.Count.ToString()); if (count == 0) { MessageBox.Show("username password does not match"); } else { this.Hide(); // hides the page as it is no longer required dbconnection.Close(); // closes the db connecection mdi_user mdi = new mdi_user(); //navigates to the mdi user mdi.Show(); //shows the defined link above } }
private void ButtonCreateAccount_Click(object sender, EventArgs e) { // opens dbconnection con = new MySqlConnection("server=localhost;user=root;database=120itdb;port=3306;password=;"); con.Open(); MySqlCommand command = con.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "Insert into library_person(`Id`, `fullname`, `username`, `password`, `email`) values (null,'" + textBoxFirstname.Text + "', '" + textBoxUsername.Text + "', '" + textBoxPassword.Text + "', '" + textBoxEmail.Text + "')"; command.ExecuteNonQuery(); // fills data into db if the following statements are correct if (!CheckTextBoxesValues()) // see the method further below, but checks if the default values are present { // check if the password equal the confirm password if (textBoxPassword.Text.Equals(textBoxConfirmPassword.Text)) { // check if this username already exists if (checkUsername()) { MessageBox.Show("This Username Already Exists, Select A Different One", "Duplicate Username", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } else { // execute the query if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Your Account Has Been Created", "Account Created, Welcome to Lend-It-Out", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Hide(); con.Close(); mdi_user mu = new mdi_user(); mu.Show(); } else { MessageBox.Show("ERROR"); } } } else { MessageBox.Show("Wrong Confirmation Password", "Password Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } } else { MessageBox.Show("Enter Your Data First", "Empty Data", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } }