private void btnLogin_Click(object sender, EventArgs e) { dbConnect.isOpen(); using (MySqlConnection con = new MySqlConnection("datasource=127.0.0.1; port = 3306;username = root; password=; database=dbLibrary; convert zero datetime=True;")) { using (MySqlCommand com = new MySqlCommand()) { com.Connection = con; com.CommandType = CommandType.Text; com.CommandText = "SELECT * FROM tblUsers WHERE username = '******' COLLATE Latin1_General_CS AND password = '******' COLLATE Latin1_General_CS ;"; try { con.Open(); MySqlDataReader sdr = com.ExecuteReader(); if (sdr.Read() == true) { //if user is existing //it will go to the main form frmUserAccount ua = new frmUserAccount(); username = txtUsername.Text; lvl = sdr.GetInt32(6); frmMain mainfrm = new frmMain(); mainfrm.Show(); this.Hide(); } else { MessageBox.Show("Incorrect username and/or password!", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception ex) { MessageBox.Show(ex.Message); } con.Close(); } } }
private void btnAccount_Click(object sender, EventArgs e) { frmUserAccount ua = new frmUserAccount(); ua.ShowDialog(); }