Ho questo codice:
codice: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(); lblUsername.Text = count.ToString(); if (count == 0) { try { SqlParameter insertUsername = new SqlParameter(); insertUsername.ParameterName = "@insertUsername"; insertUsername.DbType = DbType.String; insertUsername.Direction = ParameterDirection.Input; insertUsername.Value = txtUsername.Text; SqlParameter insertEmail = new SqlParameter(); insertEmail.ParameterName = "@insertEmail"; insertEmail.DbType = DbType.String; insertEmail.Direction = ParameterDirection.Input; insertEmail.Value = txtEmail.Text; SqlCommand cmdInsert = new SqlCommand("INSERT INTO Tabella_Account(Username, Email) VALUES(@insertUsername, @insertPassword", conn); cmdInsert.Parameters.Add(insertUsername); cmdInsert.Parameters.Add(insertEmail); cmdInsert.ExecuteNonQuery(); } catch (Exception error) { Response.Write(error.ToString()); } } }
Quando lo mando in esecuzione mi da il seguente errore:
System.Data.SqlClient.SqlException (0x80131904): Sintassi non corretta in prossimità di '@insertEmail'.
Cosa sbaglio???

Rispondi quotando