Re: making datareaders

From: "Chris Dunaway" <dunawayc@xxxxxxxxx>
Date: 3 May 2006 06:12:40 -0700

A DataReader requires a constant connection to the database and only
one DataReader can be open on a connection at once. If the Sql query
returns more than one result set, you can advance to the next one by
calling the DataReader.NextResult method.

.

Follow-Ups:
- Re: making datareaders
  - From: aaron.kempf@xxxxxxxxx

References:
- making datareaders
  - From: dbahooker
- Re: making datareaders
  - From: Chris Dunaway
- Re: making datareaders
  - From: aaron.kempf@xxxxxxxxx
- Re: making datareaders
  - From: Chris Dunaway
- Re: making datareaders
  - From: aaron.kempf@xxxxxxxxx

Prev by Date: Re: "Send To Mail Recipient"
Next by Date: Re: Attempted to read or write protected memory
Previous by thread: Re: making datareaders
Next by thread: Re: making datareaders
Index(es):
- Date
- Thread

Relevant Pages

Re: Memory leak in ASP.NET web site
... > I have a web app that makes many queries to the database on every page. ... > string to a method and I am passed a datareader or else individual values ... > There is a horrible memory leak in this application. ... > restored until SQL Server and IIS services are restarted. ...
(microsoft.public.dotnet.framework.aspnet)
Re: Memory leak in ASP.NET web site
... > I have a web app that makes many queries to the database on every page. ... > string to a method and I am passed a datareader or else individual values ... > There is a horrible memory leak in this application. ... > restored until SQL Server and IIS services are restarted. ...
(microsoft.public.dotnet.framework.adonet)
Re: Memory leak in ASP.NET web site
... > I have a web app that makes many queries to the database on every page. ... > string to a method and I am passed a datareader or else individual values ... > There is a horrible memory leak in this application. ... > restored until SQL Server and IIS services are restarted. ...
(microsoft.public.dotnet.framework.aspnet)
Re: Memory leak in ASP.NET web site
... > I have a web app that makes many queries to the database on every page. ... > string to a method and I am passed a datareader or else individual values ... > There is a horrible memory leak in this application. ... > restored until SQL Server and IIS services are restarted. ...
(microsoft.public.dotnet.framework.adonet)
Re: DataView vs DataReader
... Public Class getPerson ... ' Connect to database, ... Also, all the datareader objects, connection objects are ... Public Function GetPersonDetailsas DataView ...
(microsoft.public.dotnet.framework.aspnet)