[mb2000inc]

So, creating a data reader:

SqlDataReader reader = cmd.ExecuteReader();

...And beginning a loop with the reader.

while (reader.Read())

and when I step through the code, I get this:

Quote

InvalidOperationException was unhandled by user code
"Invalid attempt to call Read when reader is closed."

Why? And how do I fix it?
Is there something else I can do to "open" the reader?

I've already opened my SqlConnection with:

myConnection.Open();

What am I missing?

[modi123_1]

Step through your code.. where? Can we see this method?

[mb2000inc]

Actually, I realized that I'm a dork.
I closed the connection within the while loop.
Which means, the reader closed itself with the connection.

So, I moved it out of the loop and it works.

Thanks, though.

[eclipsed4utoo]

You should really be using the using blocks when dealing with SqlConnection and SqlDataReader classes. It will automatically close and dispose of the objects for you, so you don't have to.

example

// you can even stack them like this...
using (SqlConnection cn = new SqlConnection(myConnectionString))
using (SqlCommand cmd = cn.CreateCommand())
{
   cmd.CommandText = "SELECT Name FROM Person";
   
   cn.Open();

   using (SqlDataReader dr = cmd.ExecuteReader())
   {
       while(dr.Read())
       {  
           // do something
       } 
   }
}

After the code runs, the SqlConnection object, SqlCommand object, and SqlDataReader object will be closed and disposed of automatically.

[mb2000inc]

You have a valid point.