CODEWITHSUNDEEP
asp.net
Carisle
Carisle

Reputation: 467

Incorrect Syntax Near

I am new to asp.net i receive an error about incorrect syntax near ')' I don't have any idea how to fix this please help me thanks in advance

Upvotes: 0

Views: 220

Answers (1)

Darin Dimitrov
Darin Dimitrov

Reputation: 1038720

Oh, you should use parametrized queries. Here's a simplified example with 2 columns:

Using conn = New SqlConnection(SomeConnectionString)
    Using cmd = conn.CreateCommand()
        conn.open()
        cmd.CommandText = "INSERT INTO TableName (ColumnName1, ColumnName2) Values(@value1, @value2)"
        cmd.Parameters.AddWithValue("@value1", lbl_value1.Text)
        cmd.Parameters.AddWithValue("@value2", lbl_value2.Text)
        cmd.ExecuteNonQuery()
    End Using
End Using

Now adapt my example to your table schema.

Upvotes: 4

Related Questions