Yep good one ,
simular thing is also possible with SQL 2000 ( multiple resultsets ) by
just writing stored procedures and seperating the sql with a ; now with the
datareader you can use next result to get the folowing resultset
However still....... executing multiple data readers on one connection is
not possible why would someone use a datareader instead of a dataset /
datatable ? well the speed ...as a datareader is much faster if you are
only retrieving data for display purposes .
So the answer is NO you can`t use multiple data readers on a connection ,
however there are workarounds
1. go to a disconected architecture ( much slower )
2. create the datareader`s on there own connection object ( requires some
extra coding from your side )
3. use multiple resultsets
etc etc
regards
Michel Posseth [MCP]
"Greg Burns" <bl*******@newsgroups.nospam> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
There is also MARS
http://msdn2.microsoft.com/en-us/library/ms131686.aspx
Greg
"m.posseth" <mi*****@nohausystems.nl> wrote in message
news:en**************@tk2msftngp13.phx.gbl...i have checked the 2005 reference and did not found other info , so it
seems that the below info is also valid for 2005
http://msdn.microsoft.com/library/de...datareader.asp
regards
Michel Posseth [MCP]
"Kalim Julia" <ka*********@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... Is it possible to open more than 1 datareader / dataadapter on one
connection ?
Is it possible to duplicate / clone connection ?