set recordset returned by command.execute to a datagrid
I would like to know, if a recordset is derived from command.execute, how to get it into a datagrid?
my current code is like this:
dim rs as recordset
dim cmd as new command
set cmd.activeconnection = cn ' a valid connection
cmd.commandtext = "......" ' a valid sql statement
set rs = cmd.execute(,,adAsyncExecu
'here is what I tend to do:
set datagrid1.datasource = rs
'it fails on 'rowset is not bookmarkable...'
I know if I use rs.open, it will be ok, like this:
set rs = new recordset
rs.open "....",cn, adOpenStatic, adLockReadOnly
set datagrid.datasource = rs
but I don't want to do this because I need the 'adAsyncExecute' - to execute the command asynchronously.
Thanks for your help
my current code is like this:
dim rs as recordset
dim cmd as new command
set cmd.activeconnection = cn ' a valid connection
cmd.commandtext = "......" ' a valid sql statement
set rs = cmd.execute(,,adAsyncExecu
'here is what I tend to do:
set datagrid1.datasource = rs
'it fails on 'rowset is not bookmarkable...'
I know if I use rs.open, it will be ok, like this:
set rs = new recordset
rs.open "....",cn, adOpenStatic, adLockReadOnly
set datagrid.datasource = rs
but I don't want to do this because I need the 'adAsyncExecute' - to execute the command asynchronously.
Thanks for your help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The equivalent in command.execute is adAsynchFetch
See this link for specs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthcmdexecute.asp
See this link for specs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthcmdexecute.asp
http://www.w3schools.com/ado/met_rs_open.asp