is a reader automaticaly disposed if the connection it is associated with is closed?

Similar topics

by: Filip Strugar | last post by:

Considering that the BinaryWriter/BinaryReader object closes the underlaying stream upon being gc collected, is the following code correct, and if it is what is the reason preventing BinaryWriter object garbage collection after the WriteSomething method is executed? ---- using System; using System.IO;

C# / C Sharp

1364

sql reader error

by: juli jul | last post by:

Hello, I am using a reader in order to read query results: SqlDataReader rdr = null; SqlDataReader rdr_rows=null; this.conn.Open(); SqlCommand cmd = new SqlCommand("select name from sysobjects where name like '%prog%'", this.conn);

C# / C Sharp

1323

data reader question

by: Mike P | last post by:

I'm using 1 connection to open 3 separate data readers to read data into 3 data grids. However, when I try to use the 2nd reader it says that the first reader must be closed. So I use Close() to close it and now it says that 'Object reference not set to an instance of an object' on that line of code. Can anybody help me out with this? SqlConnection objConnection = new SqlConnection(ConfigurationSettings.AppSettings );

ASP.NET

5064

Invalid attempt to FieldCount when reader is closed error

by: Patrick Olurotimi Ige | last post by:

Why do i get "Invalid attempt to FieldCount when reader is closed" Is the problem the way the datareader reads data as opposed to a dataset? When trying to compile this code:- Dim reader As IDataReader = GetReader() Dim chart As New LineChart()

ASP.NET

19780

Invalid attempt to Read when reader is closed.

by: sivam.solai | last post by:

Public Function GetTopLevelThreadName(ByVal ThreadID As Integer) As SqlDataReader Sp_Datasql = "WS_Get_TopLevelThreadName" SqlParam = New SqlParameter(0) {} Try SqlParam(0) = New SqlParameter("@ThreadID", SqlDbType.Int) SqlParam(0).Value = ThreadID

ASP.NET

1698

SQL Reader Again

by: Saurabh | last post by:

Hi, I am getting the below mentioned error when I try to update a table Exception: Unable to update Person records Exception : System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. I have also set checked the time out of the server to unlimited. I am using the SQLDataReader in my applciation at quite a few palces and make it a point...

C# / C Sharp

7217

There is already an open DataReader associated with this Connection which must be closed first

by: fniles | last post by:

I am using VB.NET 2003, SQL 2000, and SqlDataReader. As I read data from tblA, I want to populate tblB. I use SQLDataReader for both tables. I do not use thread. When I ExecuteReader on tblB, I get the error "There is already an open DataReader associated with this Connection which must be closed first." How can I fix this error ? For each DataReader, do I want to open and close the connection (in this case adoCon) to avoid this error ?...

Visual Basic .NET

4769

SQL Server connection pooling

by: fniles | last post by:

I am using VB.NET 2003 and SQL 2005. To use connection pooling and avoid the error "There is already an open DataReader associated with this Connection which must be closed first." , I understand that I want to release/close connections in a timely fashion. What I do is I declare the SqlClient.SqlConnection variable as a local variable inside my subroutine (instead of a global variable). Right before I Fill the dataset I open the...