We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience.
Learn more >
Starter Kits and Source Projects
Personal Site Starter Kit
Error: Timeout expired. The timeout period elapsed prior to completi...
Re: Error: Timeout expired. The timeout period elapsed prior to comp...
View Complete Thread
Re: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or t...
Dec 01, 2005 08:25 AM
I don't know if you still have this problem or not, but I had it, and finially solved it. When you read the documentation, if you set the CommandTimeout on the connection object it is
inherited by the command object. You have to set the commandtimeout property of the SQLdata adapter, in the Select Command subset property. I set it to zero, this means it will wait until it is done. This could mean a long wait for anyone waiting on the data, so you might not want to set it zero like I did.