is it necesary to close datareader instance or it is auto closed when got out of scope.

thanks......

__________________
thanks......

It's closed when it's disposed off, which can be a little later than when it goes out of scope. Therefore, you should always Close them explicitly when possible, or wrap the Reader in a using block.

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

thanks Imar
i am on third part of yours article series regarding architecture of webapplication present on your web site. i have few things to.ask.will ask just after completing all three,

thanks......