Question

VB中DataGrid控件已经用ADO控件和数据库连接了，可是运行时无法显示数据表，下面是窗体加载代码，为什么呢

Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\DB_KFGL.mdb;Persist Security Info=False"
Adodc1.RecordSource = "select * from tb_djys"
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\DB_KFGL.mdb;Persist Security Info=False"
Adodc2.RecordSource = "select * from tb_djys"
Adodc2.Refresh

Answer 1

需要连接的是记录集啊。。。。比如：
Dim CN As New ADODB.Connection
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\NWIND.MDB;Persist Security Info=False "
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from employees ", CN, adOpenDynamic, adLockBatchOptimistic

Set DataGrid1.DataSource = Rs '这里，连接的是记录集。。。

Answer 2

我试过了有数据的，
放在Form_Lload事件里或Command1_Click事件里都行
比较奇怪，你换个数据库和表看看行不。