[abhishek415]

Hey Guys Help me finding error in this INSERT INTO Command.
My code is:

cmd.CommandText = "INSERT INTO Add (ProductID, SupplierID, PName, Quantity, Rate, ChemicalComp, Reorder) VALUES (@ProductID, @SupplierID, @PName, @Quantity, @Rate, @ChemicalComp, @Reorder)"
            With cmd
                .Parameters.AddWithValue("@ProductID", a)
                .Parameters.AddWithValue("@SupplierID", B)/>
                .Parameters.AddWithValue("@PName", c)
                .Parameters.AddWithValue("@Quantity", d)
                .Parameters.AddWithValue("@Rate", f)
                .Parameters.AddWithValue("@ChemicalComp", g)
                .Parameters.AddWithValue("@Reorder", h)
                .ExecuteNonQuery()
            End With

Please help me too.

[CharlieMay]

It would help to tell us what the error was you received.

I'm going to go ahead and assume a Syntax error as I think Add might be confusing the SQL parsing as a keyword

Either rename the table to something other than Add or wrap it with [] to denote that it is a name of a table. INSERT INTO [Add] ...

[abhishek415]

Thanks Charlie... You was write. The error was in the name of the table.