VB.net - Syntax error in ms access SQL update query

Question

I have prepared my project in vb.net with access database, but I am getting an error like "syntax error in update statement"

I have used following code:

Dim cn As New OleDb.OleDbConnection
Dim cm As New OleDb.OleDbCommand
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\NAV Vikram\DATABASE NAVPREET.mdb"
cn.Open()
cm.Connection = cn
cm.CommandText = "UPDATE DATAENTRY2  set [DIAGNOSIS]='" & TextBox13.Text & "',WHERE[opdno]='" & TextBox1.Text & "' "
cm.ExecuteNonQuery()

Any help would be appreciated.

apomene · Accepted Answer · 2017-02-09 11:28:33Z

1

omit , before WHERE and add space after it. Change:

cm.CommandText = "UPDATE DATAENTRY2  set [DIAGNOSIS]='" & TextBox13.Text & "',WHERE[opdno]='" & TextBox1.Text & "' "

to:

cm.CommandText = "UPDATE DATAENTRY2  set [DIAGNOSIS]='" & TextBox13.Text & "' WHERE [opdno]='" & TextBox1.Text & "' "

Also Use SQL parameters. (Not very keen to vb to show you example)

answered Feb 9, 2017 at 11:28

apomene

14.4k10 gold badges51 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hdkhardik · Accepted Answer · 2017-02-09 11:34:46Z

0

You have syntax error in your query. Please remove comma (,) you have used before where clause from query, as it is used to separate two different column

Dim cn As New OleDb.OleDbConnection
Dim cm As New OleDb.OleDbCommand
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\NAV Vikram\DATABASE NAVPREET.mdb"
cn.Open()
cm.Connection = cn
cm.CommandText = "UPDATE DATAENTRY2  set [DIAGNOSIS]='" & TextBox13.Text & "' WHERE[opdno]='" & TextBox1.Text & "' "
cm.ExecuteNonQuery()

edited Feb 9, 2017 at 11:34

answered Feb 9, 2017 at 11:29

hdkhardik

6624 silver badges22 bronze badges

Collectives™ on Stack Overflow

VB.net - Syntax error in ms access SQL update query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related