SQL CE Insert Error in Database

Question

I am creating an application for a PDA, when I try to insert data in the database I always find this error.

There was an error Parsing the query. [ Token line number = 1,Token line offset = 100,Token in error = ) ]

public static bool InsertPedido(int id, int Vim, DateTime date, int quantidade)
{ 
    SqlCeConnection conn = new SqlCeConnection("Data Source=" + System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + @"\\DataPedido.sdf; Password =SUPER2000PED;");

    conn.Open();
    try
    { 
        SqlCeCommand comando = new SqlCeCommand(@"INSERT INTO Pedido([IDLayout], [Vim], [Data], [Quantidade])VALUES(@IDLayout,@Vim,@Data,@Quantidade))", conn); 

        comando.Parameters.AddWithValue("@IDLatout", SqlDbType.Int).Value = id;
        comando.Parameters.AddWithValue("@Vim", SqlDbType.Int).Value = Vim;
        comando.Parameters.AddWithValue("@Data", SqlDbType.DateTime).Value = date;
        comando.Parameters.AddWithValue("@Quantidade", SqlDbType.Int).Value = quantidade;

        int row = comando.ExecuteNonQuery(); 

        return true;
    }
    catch
    {
        throw;
    }
    finally
    {
        conn.Close();
    } 
}

Answer 1

Hello... the problem is in your query. it has in the end an extra parentheses

SqlCeCommand comando = new SqlCeCommand(@"INSERT INTO Pedido([IDLayout], [Vim], [Data], [Quantidade])VALUES(@IDLayout,@Vim,@Data,@Quantidade))", conn);

The right thing would be

SqlCeCommand comando = new SqlCeCommand(@"INSERT INTO Pedido([IDLayout], [Vim], [Data], [Quantidade])VALUES(@IDLayout,@Vim,@Data,@Quantidade)", conn);

Note that at the end of Insert, before ",Conn);" had 2 parentheses ), you need to remove one of them