Close connection syntax

[Isadore]

A tidbit - which of the two would be preferred:

myConnection.Open()
dgMyGrid.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
dgMyGrid.DataBind()

...or...

myConnection.Open()
dgMyGrid.DataSource = myCommand.ExecuteReader()
dgMyGrid.DataBind()
myConnection.Close()

 

[xloop]

You can explicitly call myConnection.Close() however it's not actually necessary because the garbage collection will do this for you.

 

[James1981]

I would advise closing the connection manually - it's a good habit.

James

 

[James1981]

http://www.fawcette.com/vsm/2003_04/magazine/columns/desktopdeveloper/

James

 

[link9]

Definitely the latter.

The answer to getting answered -- faq855-2992