为什么我的DataGrid不能绑定数据呀?
代码如下:
Private Sub 执行_Click()
'connect
Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim rst As ADODB.Recordset
Set con = New ADODB.Connection
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\stock.mdb"
con.OpenSet rst = New ADODB.Recordset
rst.Open Me.tSql.Text, con, adOpenStatic, adLockReadOnlyIf Err Then
MsgBox Err.Description
Exit Sub
End If''''''''''''''''''''''''''''''''''''''
Set dc.Recordset = rst 'dc 是adodc
Set Me.dGrid.DataSource = dc
''''''''''''''''''''''''''''''''''''''End Sub
也试过用Set Me.dGrid.DataSource = rst,也是出不来,急死了
代码如下:
Private Sub 执行_Click()
'connect
Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim rst As ADODB.Recordset
Set con = New ADODB.Connection
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\stock.mdb"
con.OpenSet rst = New ADODB.Recordset
rst.Open Me.tSql.Text, con, adOpenStatic, adLockReadOnlyIf Err Then
MsgBox Err.Description
Exit Sub
End If''''''''''''''''''''''''''''''''''''''
Set dc.Recordset = rst 'dc 是adodc
Set Me.dGrid.DataSource = dc
''''''''''''''''''''''''''''''''''''''End Sub
也试过用Set Me.dGrid.DataSource = rst,也是出不来,急死了
没办法还是回头看看书,知道怎么回事了,vb的绑定要用ado控件,而不是用Recordset,添加一个控件,指定RecordSource后,Adodc.refresh就OK了
那我没看到,对不起阿
我以为你知道绑定adodc呢
用Recordset绝对可以??请教该怎么做?