Syntax error. Im not really familiar in using parameter so i dont know whats wrong with code .
i used ms access.
Private Sub btnupdate_Click(sender As System.Object, e As System.EventArgs) Handles btnupdate.Click
Dim name As String = txtfname.Text
Dim pos As String = txtpos.Text
Dim address As String = txtadd.Text
Dim contact As String = mtnum.Text
Dim username As String = txtusername.Text
Dim id As String = txtid.Text
Dim sql As String = "UPDATE tbluser SET " & _
"name ='" & _
"pos = '" & _
"address ='" & _
"contact = '" & _
"username ='" & _
"WHERE ID = '"
cmd = New OleDbCommand(sql.ToString, con)
cmd.Parameters.AddWithValue("@name", name)
cmd.Parameters.AddWithValue("@pos", pos)
cmd.Parameters.AddWithValue("@address", address)
cmd.Parameters.AddWithValue("@contact", contact)
cmd.Parameters.AddWithValue("@username", username)
cmd.Parameters.AddWithValue("@ID", id)
cmd.ExecuteNonQuery()
MsgBox("save")
End Sub