程式設計資料庫的問題(VB.NET 2003)?
程式設計vb.net2003連接access資料庫的問題整個程式沒問題可以跑的出來但在按下b1按鈕做查詢時會發生錯誤中斷da.Fill(ds, T1.Text)這邊會發生錯誤,錯誤在哪我找不到能不能幫忙修改一下???
程式碼
Imports System.Data.OleDb
Public Class Form1
Inherits System.Windows.Forms.Form
Dim obj As OleDbConnection
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim str As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "d:\db1.mdb"
obj = New OleDbConnection(str)
obj.Open()
End Sub
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim da As OleDbDataAdapter
da = New OleDbDataAdapter("select * from & t1.text", obj)
Dim ds As DataSet = New DataSet
da.Fill(ds, T1.Text)
dg.DataSource = ds.Tables(T1.Text)
obj.Close()
End Sub
End Class
2 個解答
- 匿名使用者2 0 年前最佳解答
當您的程式在執行這一行da.Fill(Ds, T1.Text)指令時, 它就會做下指令給ACCESS, 要求取回資料, 而您的SQL指令是da = New OleDbDataAdapter("select * from & t1.text", obj)這樣是不行的. 如果t1是一個TextBox, 您應該要改成da = New OleDbDataAdapter("select * from " & t1.text, obj)這樣子應該就可以解決了.
參考資料: 自己 - 匿名使用者2 0 年前
SQL錯誤!
da = New OleDbDataAdapter("select * from & t1.text", obj)
"select * from & t1.text"這個字串是不合法的SQL命令