本人寫了一段程式碼不知
為什麼不能將Database 中資料表"types" 資料顯示到Datagrid中??
Dim Objcon As ADODB.Connection
Dim Objrs As ADODB.Recordset
Set Objcon = New ADODB.Connection
Set Objrs = New ADODB.Recordset
With Objcon
.Provider = "Microsoft.Jet.OLEDB.4.0 "
.ConnectionString = DBname
.Open
End With
Objrs.Open "SELECT * FROM types", Objcon, adOpenKeyset, adLockOptimistic
Set DBGrid1.DataSource = Objrs
為什麼不能將Database 中資料表"types" 資料顯示到Datagrid中??
Dim Objcon As ADODB.Connection
Dim Objrs As ADODB.Recordset
Set Objcon = New ADODB.Connection
Set Objrs = New ADODB.Recordset
With Objcon
.Provider = "Microsoft.Jet.OLEDB.4.0 "
.ConnectionString = DBname
.Open
End With
Objrs.Open "SELECT * FROM types", Objcon, adOpenKeyset, adLockOptimistic
Set DBGrid1.DataSource = Objrs
全站熱搜
留言列表