How do I control the timeout value of a SQL connection?

You can specify the timeout value of a SQL connection within the connection string. For example, you could put the following in your application configuration file:

<add key="maindata\Connection" value="server=(local);Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Connection Timeout=30" />

You can also access this setting by means of the ConnectionTimeout property of the connection object.