作者siaujan (...)
看板Visual_Basic
标题[.NET] 从textbox读取档名开启资料表
时间Mon Apr 30 16:10:38 2007
我现在是要从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