Closing datareaders and connections. 1

[columbo2]

Hi All,

I've seen a bit on the web about closing conncetions and datareaders.

I have consequently been putting try-catch-finally blocks around my connections and datareaders and closing the connections in the finally block.

My question is: If you have a data source or datareader dragged and dropped on to the HTML page (not expilitly define in the code behind), do you need to close it in the code behind or is this done automatically?

Also, what happens if you don't close data readers, connections etc?

Do datarepeaters need to be closed as well.

Tahnks
C

 

[jmeckley]

actions like accessing files and database connections require alot of resources by the machine. by alot i mean in comparison to the other non-file access operations (loops, switch statements, equations...) because of this is always a good idea (should be required) to close/flush and dispose of resource when done.

I'm pretty sure the drag/drop objects clean up after themselves. another trick to save a few keys strokes is the using keyword.

try
{
   using (IDbConnection cnn = new SqlConnection())
   {
      new IDbCommand cmd = new SqlCommand(sql, cnn);
      cmd.ExecuteReader();
   }
}
catch(SqlException) { }

this will automatically close and dispose of the sql connection object along with any object created within the using block.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[columbo2]

Thanks Jason, great tip, I'll do that in future
C