Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Jan 20, 2010 02:31 PM|LINK
If that does not help, you can set the SQLCommandtimeout to your desired time, I mean to say you can calculate the time it takes to max execute your query and set that time as timeout.You can do that as below
SQLComm.CommandTimeout = x
replace here SQLComm by your object of sqlcommand, and X by the integer value(i.e secs).
Hope it helps,
Thanks and Regard
Please Mark as Answer if helpful :)