Should I close a datareader returned using daab?

[hansiman]

I'm unsure if I should call the close method (dr.Close()) of the
sqldatareader after the following code:

Dim dr As SqlDataReader
= SqlHelper.ExecuteReader(strConn,
CommandType.StoredProcedure, "SPROC", arParms)
If dr.Read Then
m_strValue = dr("Value")
End If


/M

 

[Steve C. Orr [MVP, MCSD]]

Yes you should.

 

[hansiman]

Thanks. And I don't need to do any other cleaning?

 

[Steve C. Orr [MVP, MCSD]]

No, that's all.

 

[Kevin Spencer]

Well, he wants to make sure that he closes his Connection as well.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

 

[hansiman]

isn't the connection handled by the daab?

 

[Scott Allen]

I'm pretty sure the DAAB uses CommandBehavior.CloseConnection as an
argument to ExecuteReader on the command object, meaning when you
close the reader the connection will be closed also

 

[Kevin Spencer]

I try not to assume anything.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.