close SqlDataReader

[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

 

[William \(Bill\) Vaughn]

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.
__________________________________