我的程序收到此错误消息.查询表达式"[ID] ="中的语法错误(缺少运算符) [英] my program got this error message.Syntax error (missing operator) in query expression '[ID]='

问题描述

cmd.CommandText =插入到ADMIN([CusID]，[Name])"& "VALUES('"& Me.txtID.Text&'，'"& Me.txtname.Text&')"

cmd.CommandText = "INSERT INTO ADMIN([CusID],[Name]) " & "VALUES('" & Me.txtID.Text & "','" & Me.txtname.Text & "' )"

        cmd.ExecuteNonQuery()

        MsgBox("Add Data Successful", MsgBoxStyle.OkOnly, "Message")

        cmd.CommandText = "UPDATE Admin " & _
                " SET" & _
                ",[Name]='" & Me.txtname.Text & "'" & _
                " WHERE [ID]=" & Me.txtID.Tag
        MsgBox("Update Data Successful", MsgBoxStyle.OkOnly, "Message")

查询表达式'[ID] ='中的语法错误(缺少运算符).

Syntax error (missing operator) in query expression '[ID]='.

推荐答案

因为Tour Me.TextBox1.Tag为空.

Because Tour Me.TextBox1.Tag is empty.

这篇关于我的程序收到此错误消息.查询表达式"[ID] ="中的语法错误(缺少运算符)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！