You get a timeout error and want to increase the timeout to run a stored procedure or a query.
Step 1: Adjust your application’s run-time execution timeout parameter. You can specify the executionTimeout attribute in the httpRuntime element in your application’s Web.config file. The executionTimeout property indicates the maximum number of seconds a request is allowed to execute before being automatically shut down by ASP.NET. The default is 90 seconds in .NET Framework 1.0 and 1.1 applications; it is 110 seconds in .NET Framework 2.0 applications.
<httpRuntime
maxRequestLength="10240"
executionTimeout="90"
/>
For more details see:
Step 2: Set the Microsoft SQL Server Query timeout value if you are using Microsoft SQL Server. In the Microsoft SQL Server Enterprise Manager, open the SQL Server Properties (properties for the entire server) by right mouse clicking the server node in the tree. Select the Connection tab and set Query Timeout as desired. You can set the query timeout to 0 for indefinite or no timeout.
Part VII: Troubleshooting Applications
Application Runs But No Data is Displayed