Execution Timeout Expired. The timeout period elapsed prior

Question

When I fatch Record In Asp.Net From sql server This error is Come Execution Timeout Expired. The timeout period elapsed prior Help..

Pravat Kumar · Answer

thank you for your suggestion @Vatsal

Vatsal Desai · Answer

Thnks For help its working but suggestion from my side declare "Connect Timeout" in the connection string Database=WIMS;Server=(local);User Id =(Username); Password=(password);Connect Timeout=0" 2. SqlCommand.CommandTimeout using (var connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand("SpGetEmployee", connection); command.CommandType = CommandType.StoredProcedure; // Setting command timeout to 0 second so it go to infinity command.CommandTimeout = 0; command.ExecuteNonQuery(); }

Pravat Kumar · Answer

Hi Vatsal, If your query needs more than the default 30 seconds, use below code. 1. declare "Connect Timeout" in the connection string Database=WIMS;Server=(local);User Id =(Username); Password=(password);Connect Timeout=3000000" 2. SqlCommand.CommandTimeout using (var connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand("SpGetEmployee", connection); command.CommandType = CommandType.StoredProcedure; // Setting command timeout to 3000000 second command.CommandTimeout = 3000000; command.ExecuteNonQuery(); }

Execution Timeout Expired. The timeout period elapsed prior

Answers (3)