Hi..A dobut in SqlDataReader..

[satheesh p]

Hi Group..

 

      I have a doubt in SQL DataReader, is there any way to close the connection automactically if i close the DataReader Object.

 

       What i mean i should explictly close only the datareader object which should close the connection object.

 

Thanks

Satheesh    

[Shivprasad Koirala]

you have to do pass the commanbehavour enum to execute reader
ExecuteReader(CommandBehavior.CloseConnection)

-------
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/
My Interview Blog
http://spaces.msn.com/members/dotnetinterviews/

[Juneja Tarun]

also you can use using()
which automatically manage all this.
You create an instance in a using statement to ensure that Dispose is
called on the object
when the using statement is exited

the syntex is

using( //create object here)
{
do processing here
}

[Thread]

I agree with what juneja has mentioned

[satheesh p]

Thanks Guys..

 

        Thanks for you valuable inputs..

 

 

On 11/8/05, Thread <manish...@gmail.com> wrote:

I agree with what juneja has mentioned

--
Satheesh P
Software Engineer.