How to change parameters for timeout errors?

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

This error occurs when the execution time beyond Timeout Property. When you are trying to connect or access to a Database table which is having large volume of data, query execution time will be more. There are two main Timeout property in ADO.NET.

1. Connection Timeout for Connection. It could be solved by setting ConnectionTimeout property of Connection object in Connection String.
2. Timeout for Data access ( Command Object ). You can set CommandTimeout property to Command object. I recommend you set CommandTimeOut property to bigger one value.