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).
NiravVyas
Participant
912 Points
217 Posts
Re: SQL Statement Timeout
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
Nirav Vyas,
Please Mark as Answer if helpful :)
Thanks
Nirav