别用那个控件了,引用ado dim rst as new adodb.recordset dim cnn as new adodb.connection dim sql as string sql="……" rst.Open sql, cnn, adOpenKeyset, adLockPessimistic Set DataEnvironment1.rsCommand1.DataSource = rst Set DataReport1.DataSource = DataEnvironment1 DataReport1.Show
If DataEnvironment1.rsCommand1.State = adStateOpen Then DataEnvironment1.rsCommand1.Close End If 我用了上面的语句,但是我要点击两次预览报表,报表才有变化? 谢谢
If DataEnvironment1.rsCommand1.State = adStateOpen Then DataEnvironment1.rsCommand1.Close End If DataEnvironment1.rsCommand1.open
问:shuchang0626(舒畅) dim rst as new adodb.recordset dim cnn as new adodb.connection dim sql as string sql="select * from 地址库 where 地址=天津" rst.Open sql, cnn, adOpenKeyset, adLockPessimistic Set DataEnvironment1.rsCommand1.DataSource = rst Set DataReport1.DataSource = DataEnvironment1 DataReport1.Show 在运行后,系统报错“实时错误 3709 — 连接无法用于此操作,在上下文中它可能已关闭或无效” 报错语句:rst.Open sql, cnn, adOpenKeyset, adLockPessimistic
datareport.show
dim rst as new adodb.recordset
dim cnn as new adodb.connection
dim sql as string
sql="……"
rst.Open sql, cnn, adOpenKeyset, adLockPessimistic
Set DataEnvironment1.rsCommand1.DataSource = rst
Set DataReport1.DataSource = DataEnvironment1
DataReport1.Show
DataEnvironment1.rsCommand1.Close
End If
我用了上面的语句,但是我要点击两次预览报表,报表才有变化?
谢谢
DataEnvironment1.rsCommand1.Close
End If
DataEnvironment1.rsCommand1.open
dim rst as new adodb.recordset
dim cnn as new adodb.connection
dim sql as string
sql="select * from 地址库 where 地址=天津"
rst.Open sql, cnn, adOpenKeyset, adLockPessimistic
Set DataEnvironment1.rsCommand1.DataSource = rst
Set DataReport1.DataSource = DataEnvironment1
DataReport1.Show
在运行后,系统报错“实时错误 3709 — 连接无法用于此操作,在上下文中它可能已关闭或无效”
报错语句:rst.Open sql, cnn, adOpenKeyset, adLockPessimistic
cnn.connectionstring =""
CNN.OPEN