Timeout expired error

[meena_alag]

Hi,

How do I avoid the following error:

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

My sql query takes 1 min to fetch 1 lakh records. I have set the
CommandTimeOut in C# to 3 mins and still i am getting the above
error.

Please suggest a solution to this issue asap.

Thanks in advance,
Meena

 

[W.G. Ryan eMVP]

It could be the connection timeout that's giving you the problem- but it's a
readonly property unless you set it in the connection string.