Ragazzi, cosa c'è di sbagliato nella mia query che mi restituisce l'errore riportato in fondo?
Errore:codice:SqlParameter pUsername = new SqlParameter(); pUsername.ParameterName = "@Username"; pUsername.DbType = DbType.String; pUsername.Direction = ParameterDirection.Input; pUsername.Value = txtUsername.Text; SqlParameter pEmail = new SqlParameter(); pEmail.ParameterName = "@Email"; pEmail.DbType = DbType.String; pEmail.Direction = ParameterDirection.Input; pEmail.Value = txtEmail.Text; using (SqlConnection conn = new SqlConnection(builder.ConnectionString)) { try { conn.Open(); } catch (Exception excMessage) { Response.Write(excMessage.ToString()); } using (SqlCommand cmqQuery = new SqlCommand("SELECT COUNT(*) FROM Tabella_Account WHERE Username=@Username OR Email=@Email", conn)) { cmqQuery.Parameters.Add(pUsername); cmqQuery.Parameters.Add(pEmail); int count = (int)cmqQuery.ExecuteScalar(); MailStatus = count.ToString(); lblUsername.Text = MailStatus; } }
I tipi di dati text e nvarchar nell'operatore equal to sono incompatibili.![]()