No. It’s per command, not per connection.
Edit, May 2013
As requested in comment:
- SQLCommand.CommandTimeout for command execution
- There is no matching SQLConnection property (the questions says not the SqlConnection.ConnectionTimeout property
Some more notes about commands and execution time outs in SQL Server (DBA.SE).
And more SO stuff: What happens to an uncommitted transaction when the connection is closed?