ASP.net SQLdataredar

i am new to asp.net

i want to openSqlDataReader inside alredy opend sqldatareder

How to open a sqldatareader with out close the opend previous datareder

please help regarding this

TX,

Ganesh R

That sounds like a bad idea to me. a DataReader has an open connection to the db and this connection needs to be opened as late as possible and closed as soon as possible so it can go back to the connection pool and be re-used.

If you start opening additional connections while you have an open DataReader you are going to have performance and scalability problems.

|||Create a second connection object that the second datareader will use.|||

Hi,

GaneshIsolve:

i want to openSqlDataReader inside alredy opend sqldatareder

what's your scenario? You can have multiple select statements in the same call and "jump" to the next select statement after looping over the current result with theNextResult() method.

Grz, Kris.