The connection object is required througout the life of the application. So it should be opened on the first form load and then closed only at the end of the application.