i am getting the Sysntax Error given below while Exeuting the query
Syntax Error='Syntax Error in Update Statement'
Private Sub btnupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnupdate.Click
Dim sqlupdate As String
Try
Dim i As Integer
sqlupdate = "UPDATE Customer_Master SET Names='" & txtname.Text & "', Address='" & txtaddr.Text & "', PhoneNo='" & txtphno.Text & "' WHERE CustomerID='" & txtcid.Text & "'"
conn.Open()
cmd = New OleDb.OleDbCommand(sqlupdate, conn)
i = cmd.ExecuteNonQuery()
cmd.Dispose()
MsgBox("Customer updated")
txtcid.Text = ""
txtname.Text = ""
txtaddr.Text = ""
txtphno.Text = ""
Call RefreshDGV()
Catch ex As Exception
MessageBox.Show(ex.Message.ToString())
Finally
If conn.State = ConnectionState.Open Then
conn.Close()
End If
End Try
End Sub