7,763
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
taoyiwan 2004-02-02
- 打赏
- 举报
Set datagrid1.DataSource = rs 能行吗？
偶试了几次都绑定不了，试试！
偶试了几次都绑定不了，试试！
wsd309 2004-02-02
- 打赏
- 举报
up
HRamBo 2004-02-02
- 打赏
- 举报
Set datagrid1.DataSource = 记录集
wxrwan 2004-02-01
- 打赏
- 举报
同意楼上的！
northwolves 2004-02-01
- 打赏
- 举报
Dim cnn As New ADODB.Connection
Dim strsql As String
Dim rs As New ADODB.Recordset
' cnn.ConnectionString=......设置连接字符串
'strSQL = "SELECT * FROM table1 where ...."设置记录集
With rs
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open strsql, cnn, , , adCmdUnknown
End With
Set datagrid1.DataSource = rs
Dim strsql As String
Dim rs As New ADODB.Recordset
' cnn.ConnectionString=......设置连接字符串
'strSQL = "SELECT * FROM table1 where ...."设置记录集
With rs
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open strsql, cnn, , , adCmdUnknown
End With
Set datagrid1.DataSource = rs
