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();
}
