visual-studio - 预计声明结束/VB 2017

Question

我正在使用 Visual Basic 2017 和 SQL Express 数据库。我正在尝试执行插入、更新删除页面以将用户添加到我的数据库。我收到一条错误消息，提示“此代码预期语句结束”。

Private Sub btnUpdate_Click(sender As Object, e As EventArgs) Handles btnUpdate.Click

    Dim updateQuery As String = "Update users Set Code = " & txtCode.Text & " WHERE JudgeID = " & txtJudgeID.Text " "

    ExecuteQuery(updateQuery)
    MessageBox.Show("Data Updated")

End Sub

标签： visual-studiosql-server-expressbasic

Answer 1

您很可能缺少&betweentxtJudgeID.Text和" "。更改以下行：

Dim updateQuery As String = "Update users Set Code = " & txtCode.Text & " WHERE JudgeID = " & txtJudgeID.Text " "

至

Dim updateQuery As String = "Update users Set Code = " & txtCode.Text & " WHERE JudgeID = " & txtJudgeID.Text & " "