Dim sqlstr As String
Dim connstr As String
connstr = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Data Source=H:\database\Testdb.mdb"
sqlstr = "select * from jsj"
Adodc1.ConnectionString = connstr
Adodc1.RecordSource = sqlstr
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
DataGrid1.Refresh
搞定了,别忘了加分:)
Dim connstr As String
connstr = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Data Source=H:\database\Testdb.mdb"
sqlstr = "select * from jsj"
Adodc1.ConnectionString = connstr
Adodc1.RecordSource = sqlstr
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
DataGrid1.Refresh
搞定了,别忘了加分:)
ConnStr = "……"
SqlStr = "……"
Adodc1.ConnectionString = ConnStr
Adodc1.RecordSource = SqlStr
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
DataGrid1.Refresh