mysql - 检查与您的 mariadb 服务器版本对应的手册，了解在第 1 行 "user"附近使用的正确语法

Question

我的表单中有一个文本框、按钮和 datagridview。当我单击按钮时，系统将根据我的文本框从数据库中获取一个表并显示在 datagridview 上。

当我单击按钮时，出现此错误。我哪里错了？

这是我的 dbconn

Module mod_dbconn
Public conn As MySqlConnection
Public Sub openDB()
    Dim dbname As String = scr_sales.btn_dbswitch.Text
    Dim server As String = "localhost"
    Dim user As String = "root"
    Dim password As String = ""

    Try
        conn = New MySqlConnection
        conn.ConnectionString = String.Format("server={0}; user id={1}; password={2}; database={3}; pooling=false", server, user, password, dbname)

        If conn.State = ConnectionState.Closed Then
            conn.Open()
        End If

    Catch ex As Exception
        MsgBox(ex.Message)
    End Try
End Sub

这是我的表格

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
    Dim query As String = "SELECT * FROM '" + TextBox1.Text + "'"
    Dim cmd As New MySqlCommand(query, conn)
    Dim da As New MySqlDataAdapter(cmd)
    Dim dt = New DataTable
    Dim cb As MySqlCommandBuilder



    cb = New MySqlCommandBuilder(da)
    DataGridView1.Refresh()

    Try
        conn.Open()
        da.Fill(dt)

        Dim bsource As New BindingSource
        bsource.DataSource = dt

        Me.DataGridView1.DataSource = bsource
        da.Update(dt)

        conn.Close()
    Catch ex As Exception
        MessageBox.Show(ex.Message)
    Finally
        conn.Dispose()
    End Try
End Sub

Answer 1

您正在尝试构建动态表选择，因此对于表名称，您不需要在表名称周围加上引号

 "SELECT * FROM " + TextBox1.Text + " ;"