查询表达式'Student ID ='EO001'AND Password ='apples'中的语法错误(缺少运算符) [英] Syntax error (missing operator) in query expression 'Student ID = 'EO001' AND Password = 'apples''

问题描述

我正在Visual Basics 2010 Express中编写登录表单，但一直出现此错误:查询表达式'Student ID ='EO001'AND Password ='apples'中的语法错误(缺少运算符).

I am coding a login form in Visual Basics 2010 Express and I keep having this error: Syntax error (missing operator) in query expression 'Student ID = 'EO001' AND Password = 'apples''.

这是我的代码:

Imports System.Data.OleDb
Public Class frmStudentLogin


    Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
        Dim con As New OleDbConnection("Provider=Microsoft.ACE.oledb.12.0;data source=C:\Users\Harry\Desktop\Database.accdb")
        Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM Login Student WHERE Student ID = '" & txtLogin.Text & "' AND Password = '" & txtPassword.Text & "' ", con)
        con.Open()
        Dim sdr As OleDbDataReader = cmd.ExecuteReader()
        ' If the record can be queried, Pass verification and open another form.  
        If (sdr.Read() = True) Then
            MsgBox("Welcome")
        Else
            MsgBox("Invalid user / pass")
        End If
    End Sub

End Class

推荐答案

尝试

Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM [Login Student] WHERE [Student ID] = '" & txtLogin.Text & "' AND [Password] = '" & txtPassword.Text & "' ", con)

Yu必须记住，如果表/列名称中有空格，则需要用方括号将其包裹起来.

Yuo have to remember that if you have spaces in the table/column names, you need to wrap them with square brackets.

所以

SELECT [Column] FROM [Table] Where [Where] = 0 ORDER BY [Order]

这篇关于查询表达式'Student ID ='EO001'AND Password ='apples'中的语法错误(缺少运算符)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！