Proper use of a database connection

Question

I have a Winforms program that connects to SQL Server 2008.

There are 100 users who connect to this database and

run a search query -> and update the database.

I open the connection when the program starts and closes when the program ends.

Is this right to do?

Is it better to open a connection → execute a query → update → and close the connection?

Thanks in advance

Answer 1

is it better to open a connection → execute a query → update → and close the connection?

, SQL Server ADO.Net. , , , . SQL .

MSDN ( ):

, , .

Answer 2

, , .

, → SQL → Close.

. ( ), .

Answer 3

, . , . , , , .