vb.net - false 子句中的语法错误，当我搜索名称时没有显示

Question

有一次，当我运行这段代码时，它运行顺利，但是当我搜索名称时，没有出现任何记录。我们的项目项目非常需要你们的帮助。提前致谢 ：）

这是我的代码：

Private Sub search_btn_Click(sender As Object, e As EventArgs) Handles search_btn.Click
    Me.Show()
    Search_Record()

End Sub

Private Sub Search_Record()
    Dim conn As New OleDbConnection
    Dim cmd As New OleDbCommand
    Dim da As New OleDbDataAdapter
    Dim dt As New DataTable
    Dim sSQL As String = String.Empty

    Try

        conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\VB\HSU\HSU\G11B.mdb"

        conn.Open()
        cmd.Connection = conn
        cmd.CommandType = CommandType.Text
        sSQL = "SELECT Last_Name, First_Name FROM 10ABM"
        sSQL = sSQL & "WHERE Last_Name like '%" & Me.search_txt.Text & "%'"
        cmd.CommandText = sSQL
        da.SelectCommand = cmd
        da.Fill(dt)
        Me.DataGridView1.DataSource = dt
        If dt.Rows.Count = 0 Then
            MsgBox("No record found!")
        End If
    Catch ex As Exception
        MsgBox(ErrorToString)
    Finally
        conn.Close()
    End Try

End Sub

标签： vb.net