Dim Conn As New ADODB.Connection
Dim rs As New ADODB.RecordsetPrivate Sub Command1_Click()
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\myProject\Temp\data.mdb;Persist Security Info=False"
Conn.Open
rs.Open "select * from caiwu", Conn, adOpenStatic, adLockReadOnly
Set DataGrid1.DataSource = rs
DataGrid1.Refresh
End Sub
为什么datagrid1没反应啊?奇怪!!谢谢大家了!帮帮我吧!
Dim rs As New ADODB.RecordsetPrivate Sub Command1_Click()
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\myProject\Temp\data.mdb;Persist Security Info=False"
Conn.Open
rs.Open "select * from caiwu", Conn, adOpenStatic, adLockReadOnly
Set DataGrid1.DataSource = rs
DataGrid1.Refresh
End Sub
为什么datagrid1没反应啊?奇怪!!谢谢大家了!帮帮我吧!
rs.CursorLocation = adUseClient
rs.Open "select * from caiwu", Conn, adOpenStatic, adLockReadOnly
Dim rs As New ADODB.RecordsetPrivate Sub Command1_Click()
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\myProject\Temp\data.mdb;Persist Security Info=False"
Conn.Open
rs.CursorLocation = adUseClient
rs.Open "select * from users", Conn, adOpenStatic, adLockReadOnly
MsgBox rs.RecordCount & rs.Fields(0)
Set DataGrid1.DataSource = rs
DataGrid1.Refresh
End Sub
外,在设计时,也不能给datasource设置值,如果设置了值,并检索了datagrid字段,则
以上代码根本不会显示出来,你可以放置一个不设置任何属性的datagrid控件试一试。