[.NET] 從textbox讀取檔名開啟資料表

[siaujan (...)]

我現在是要從TextBox(tb1)讀取檔名來開啟comicDB裡面的資料表，
撰寫的時候是沒問題，但是執行時就發生錯誤了

執行的錯誤有黃底的地方，還有標灰底
說是FROM語法錯誤..不過我刮號什麼的試了幾個方法還是錯 囧

請問一下各位前輩，程式是哪裡出問題了呢orz

====

Imports System.Data.OleDb
Public Class record
    Dim objDataSet As DataSet

    Private Sub record_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
        openName(tb1.Text)
    End Sub

    Sub openName(ByVal str As String)
        Dim objCon As OleDbConnection
        Dim objDataAdapter As OleDbDataAdapter
        Dim strDbCon As String
        strDbCon = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source =
comicDB.mdb"
        objCon = New OleDbConnection(strDbCon)
        objCon.Open()
        objDataAdapter = New OleDbDataAdapter("SELECT * FROM " & str & "",
objCon)
        objDataSet = New DataSet()
        objDataAdapter.Fill(objDataSet, "comicDB")
    End Sub
End Class

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 59.113.15.86