private void BackButton_Click(object sender, EventArgs e)
{
this.Hide();
MainMenuForm mmf = new MainMenuForm();
mmf.Show();
}
private void LoginButton_Click(object sender, EventArgs e)
{
string login = loginField.Text;
string password = passwordField.Text;
DataTable userTable = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
string query = "SELECT * FROM `users` WHERE `login` = @login AND `password` = @password ";
MySqlCommand command = new MySqlCommand(query, db.GetConnection());
command.Parameters.Add("@login", MySqlDbType.VarChar).Value = login;
command.Parameters.Add("@password", MySqlDbType.VarChar).Value = password;
adapter.SelectCommand = command;
adapter.Fill(userTable);
if (userTable.Rows.Count > 0)
{
MessageBox.Show("Success!Authorization");
this.Hide();
MainMenuForm menu = new MainMenuForm();
menu.Show();
}
else
{
MessageBox.Show("No");
}
}
