to close connection to database after i use or not ?

[C# Programming]

hi

is it be better to open connection to database -

make any querys...update....delete -

and after i use to close this connection

or

open the connection when the program load -

and close when the program close ?



thanks in advance