[C#] Problema con query INSERT parametrica

[dwb]

Ho questo 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???

[URANIO]

Nella seconda query il parametro è @InsertPassword non @insertEmail

[dwb]

Corretta la query, cambiato l'errore:

System.Data.SqlClient.SqlException (0x80131904): Sintassi non corretta in prossimità di '@insertEmail'

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 FANTAWIT_Account(Username, Email) VALUES(@insertUsername, @insertEmail", conn);
                                
                                cmdInsert.Parameters.Add(insertUsername);
                                cmdInsert.Parameters.Add(insertEmail);


                                
                                cmdInsert.ExecuteNonQuery();
                            }


                            catch (Exception error)
                            {
                                Response.Write(error.ToString());


                            }


                            
                        }


                    }

[URANIO]

Manca una parentesi finale nella seconda query

[dwb]

Manca una parentesi finale nella seconda query

Dove di preciso? Sto sbattendo la testa da due giorni!

P.S. Trovata:

SqlCommand cmdInsert = new SqlCommand("INSERT INTO Tabella_Account(Username, Email) VALUES(@insertUsername, @insertEmail)", conn);