About Insert Into query using where clause

[vabh]

I am using access connection like-

a = TextBox2.Text.Remove(1)
        a = TextBox2.Text.Remove(1)
        c = TextBox3.Text.Remove(1)
        b = TextBox4.Text
        TextBox5.Text = a + c + " " + b
        Dim com As New OleDbCommand("INSERT INTO Employees(Code) VALUES(@cd) WHERE Sr_No='" & TextBox1.Text & "'", Connect.OledbConnection())
        com.Parameters.AddWithValue("@cd", TextBox5.Text)
        com.Connection.Open()
        com.ExecuteNonQuery()
        com.Connection.Close()
        MsgBox("OK")
        'Catch ex As Exception
        ' MsgBox(ex.Message)
        'End Try

but there is a problem inwhere clause it is giving me error as "Missing semicolon (;) in SQL statement...
Is there any solution for that ?

[QVeen72]

Hi,

You will get the error if any of the Textboxes have a Single or Double Quote..
' Or "

Before updation you have to check, and remove those chars..

REgards
Veena

[debasisdas]

Why using where clause in insert into statement ?

Either remove the where clause of use Update statemnet.