private void loginbutton_Click(object sender, EventArgs e)
{
i = 0;
MySqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from user_account where u_id='" + usernametextbox.Text + "'and password='******'";
cmd.ExecuteNonQuery();
var name = usernametextbox.Text;
comm = con.CreateCommand();
comm.CommandText = "Insert into project.login_his values @u_id";
comm.Parameters.AddWithValue("@u_id", name);
UserInfo.Name = usernametextbox.Text;
DataTable dt = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
i = Convert.ToInt32(dt.Rows.Count.ToString());
if (i == 0)
{
MessageBox.Show("The username or password is incorrect. Try again!");
usernametextbox.Clear();
passwordtextbox.Clear();
usernametextbox.Select();
}
else
{
string data = usernametextbox.Text;
register_login newform = (register_login)Application.OpenForms["register_login"];
newform.Close();
this.Close();
Acc fm = new Acc(data);
fm.Show();
con.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
register_login f2 = new register_login();
f2.ShowDialog();
}