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(,,adAsyncExecute)

'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

LVL 4
ChenChenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rick_TownsendCommented:
You should be able to use adAsyncExecute after the locktype in recordset.open command.

rs.open "....",cn, adOpenStatic, adLockReadOnly, adAsyncExecute
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rick_TownsendCommented:
0
Rick_TownsendCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.