close SqlDataReader

  • Thread starter Thread starter Ruslan
  • Start date Start date
R

Ruslan

Hi,

I have the following code:



using (SqlConnection connection = DBConnector.GetConnection())

{

SqlCommand cm = new SqlCommand();



SqlDataReader dr = new SqlDataReader (cm.ExecuteReader());



while (dr.Read())

{

...

}

}



There is no dr.Close() because the "connection" is closed when it is out of
"using". How it important to add dr.Close()?





Thanks,



Ruslan
 
Do it anyway. Close the DataReader and the Connection in your Finally.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top