private void loginAcceptBtn_Click(object sender, EventArgs e)
{
Student_Database db = new Student_Database();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DataTable table = new DataTable();
MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `username` = @usn AND `password` = @pass", db.getConnection);
command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = usernameTextbox.Text;
command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = passwordTextbox.Text;
adapter.SelectCommand = command;
adapter.Fill(table);
if (table.Rows.Count > 0)
{
//MessageBox.Show("Logowanie powiodło się!","Wskakuj!", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
}
else if (endCounter == 1)
{
this.DialogResult = DialogResult.No;
Application.Exit();
}
else
{
endCounter--;
MessageBox.Show("Niepoprawne hasło i login\n Zostało prób:" + endCounter, "Błąd logowania", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
