Timeout expired.

VINAY KUMAR

I GOT ERROR LIKE THIS ...PLZ RESOLVE MY ERROR

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

Line 69:                     paramout.Direction = ParameterDirection.Output;
Line 70:                     objCmd.Parameters.Add(paramout);
Line 71:                     objCmd.ExecuteNonQuery();
Line 72:                     string outmsg = paramout.SqlValue.ToString();
Line 73:                     return outmsg;

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
hi,
before you increce time out property of Sqlcommand, make sure your query is highly optimize, proper indexes create on tables.
and more important in any where of your project dead lock is not created!..
hope this will help you.
Kunal Vaishya13y ago
SqlConnection ObjConn = new SqlConnection("Connection String");
SqlCommand ObjCmd = new SqlCommand("Command String", ObjConn);
ObjCmd.CommandTimeout = 10000;
ObjCmd.ExecuteNonQuery();
Amit Choudhary13y ago
If you long running db query then you can Increase the timeout in command object or probably in Connection string like ;Connection Timeout=30.
Iftikar Hussain13y ago
Hi,
Increase the time out value in connection string as shown below
string connstring="Data Source=localhost;User ID=sa; pwd=password; Initial catalog=nothwind;connect timeout=900;

Then set command object timeout
com.CommandTimeout=0; // this will makes Command to execute unlimited seconds

and always dispose connection object

Regards,
Iftikar