本人寫了一段程式碼不知
為什麼不能將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
arrow
arrow
    全站熱搜

    vbqa 發表在 痞客邦 留言(2) 人氣()