Question about DataAccess Block

[ad]

I user DataAccess Block in my progrm.
http://www.microsoft.com/downloads/...0A-9877-4A7B-88EC-0426B48DF275&displaylang=en

I often uses the code:
string sSql="Select...";
string cnnStr="....";
SqlDataReader dr=SqlHelper.ExecuteReader(cnnStr, CommandType.Text, sSql);
.....
dr.Close();

Dose it will colose the connection when I close the SqlDataReader with
dr.Close()?

 

[Chris Taylor]

Hi,

Yes, IIRC this overload of ExecuteReader ultimately passes
CommandBehaviour.CloseConnection to the call to ExecuteReader on the command
object. This causes the connection to be closed when the reader is closed.

Hope this helps