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"); }