how to fix timeout expired in C#.net and MS sql server

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();

}