private void bConnect_Click(object sender, EventArgs e) { byte[] login = Encoding.ASCII.GetBytes(tbLogin.Text); byte[] password = Encoding.ASCII.GetBytes(tbPassword.Text); string connectionResponse = _databaseConnection.CheckConnection(login, password); consoletest.Items.Add(connectionResponse); if (connectionResponse == "Good Password") { string comm = $"SELECT * FROM users WHERE USERNAME = '******' AND USERPASS = '******'"; string acctype = _databaseConnection.SQLGetParam(comm, "usertype"); consoletest.Items.Add(acctype); string getiduser = $"SELECT * FROM users WHERE USERNAME = '******'"; string iduser = _databaseConnection.SQLGetParam(getiduser, "userid"); _loggedUserConnection = new UserConnection(login, password, int.Parse(acctype), int.Parse(iduser)); _loggedUserConnection.GetMessages(_databaseConnection); lstTitre = _loggedUserConnection.GetTitres(lstTitre); } else { consoletest.Items.Add("Could not log in"); } }