private void loginButton_Click(object sender, EventArgs e) { try { string myConnection = "datasource=localhost;port=3306;database=pharma;username=root;password="******"SELECT * FROM pharma.users WHERE username='******' and password='******' ; ", myConn); MySqlDataReader myReader; myConn.Open(); myReader = SelectCommand.ExecuteReader(); int count = 0; while (myReader.Read()) { count = count + 1; } if (count == 1) { MessageBox.Show("User name and Password is correct ..Access Granted"); this.Hide(); frmUsers f = new frmUsers(); f.ShowDialog(); } else if (count > 1) { MessageBox.Show("Duplicate User Name and Password ...Access Denied"); } else { MessageBox.Show("User Name and Password is Not Correct ..Please Try Again"); } myConn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void loginButton_Click(object sender, EventArgs e) { try { string myConnection = "datasource=localhost;port=3306;database=pharma;username=root;password="******"SELECT * FROM pharma.users WHERE username='******' and password='******' ; ", myConn); MySqlDataReader myReader; myConn.Open(); myReader = SelectCommand.ExecuteReader(); int count = 0; while (myReader.Read()) { count = count + 1; } if (count == 1) { MessageBox.Show("User name and Password is correct ..Access Granted"); this.Hide(); frmUsers f = new frmUsers(); f.ShowDialog(); } else if (count > 1) { MessageBox.Show("Duplicate User Name and Password ...Access Denied"); } else MessageBox.Show("User Name and Password is Not Correct ..Please Try Again"); myConn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }