private void LoginButton_Click(object sender, EventArgs e)
{
// mySQLconnection.Open();
/*
MySqlCommand mySQLcommand = new MySqlCommand("SELECT * FROM SUser WHERE username = @username AND password = @password");
if (this.OpenConnection() == true)
{
mySQLcommand.Parameters.AddWithValue("username", UsernameTextBox.Text);
mySQLcommand.Parameters.AddWithValue("password", PasswordTextBox.Text);
MySqlDataReader dataReader = mySQLcommand.ExecuteReader();
while(dataReader.Read())
{
mainpage = new MainPage();
mainpage.Show();
}
dataReader.Close();
}
//mainpage = new MainPage();
// mainpage.Show();
* */
DBConnect db = new DBConnect();
DataTable dataTable = db.GetUser(PasswordTextBox.Text, UsernameTextBox.Text);
if (dataTable != null)
{
mainpage = new MainPage();
mainpage.Show();
//MessageBox.Show(dataTable.ToString());
}
else MessageBox.Show("Noe gikk galt");
}
