private void login_Click(object sender, EventArgs e)
{
string user = username.Text;
string pass = password.Text;
string query = "SELECT * FROM users WHERE username = '******' AND password ='******';";
conn.Open();
MySqlCommand comm = new MySqlCommand(query, conn);
MySqlDataAdapter adap = new MySqlDataAdapter(comm);
conn.Close();
DataTable tbl = new DataTable();
adap.Fill(tbl);
if (tbl.Rows.Count == 1)
{
Main_menu main = new Main_menu();
main.getUsername = tbl.Rows[0]["username"].ToString();
main.getUsertype = tbl.Rows[0]["user_type"].ToString();
main.getUid = tbl.Rows[0]["user_id"].ToString();
main.getFname = tbl.Rows[0]["firstname"].ToString();
main.getLname = tbl.Rows[0]["lastname"].ToString();
main.prev = this;
this.Hide();
setNull();
main.Show();
}
else if (username.ForeColor == Color.Gray || password.ForeColor == Color.Gray)
{
MessageBox.Show("You did not enter a username or password!");
}
else
{
MessageBox.Show("The username or password is incorrect.");
}
}