question about using connection

[Eric]

Hi,

i use this for a database connection:

Using mConnection As New SqlConnection(param.ConnectionString)
mConnection.Open()
sql = "insert ...."
comd = New SqlCommand(sql, mConnection)
comd.ExecuteNonQuery()
End Using

My question is: do i need to close the connection with: mConnection.Close()
or does the End Using do itself?

thanks
Eric

 

[Andy B.]

The end using statement closes it. If you don't use the using statement you
would have to close it yourself.

 

[Eric]

thanks

The end using statement closes it. If you don't use the using statement
you would have to close it yourself.

 

[Eliyahu Goldin]

Find here more details:

http://stackoverflow.com/questions/376068/does-end-using-close-an-open-sql-connection