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

"Ruslan" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>
>