Closing database connections in 3 tier

[MrNorth]

Im a big fan of 3 tier architecture. As a result of that I perform all my db readings in the datalayer... And when a reading is finished or the reading resulted in error I always close my connection
Is this the best way to do it? Either before I return my data or in the finally statement:

If Not myConnectionOra Is Nothing AndAlso myConnectionOra.State = ConnectionState.Open Then
                myConnectionOra.Close()
            End If

kind regards
Henrik