Sql Server connection timeout

Question

I'm trying to execute a sql server query through asp.net but the following exception occurs : "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

My connection string timeout is 300000 and remote query timeout in sql server is 60000 how can i solve this problem

Answer 1

The problem is with the command timeout, i solved the problem with the following line of code :

command.CommandTimeout = 30000;

but the question now : how can i set commandTimeout default value over the application