Timeout when calling fill method for dataadapter object

  • Thread starter Thread starter William C
  • Start date Start date
W

William C

I set the Connect String for connection objec to 60
seconds then set the connection object to DataAdapter
object. I then call the Fill method on the DataAdapter
object and at times it timesout in about 30 seconds. Is
there a seperate timeout setting for the method itself? I
couldn't find any other timeout settings other than the
one in the Connection object which I explicitly set.
Thanks in advance for your help.
 
William C said:
I set the Connect String for connection objec to 60
seconds then set the connection object to DataAdapter
object. I then call the Fill method on the DataAdapter
object and at times it timesout in about 30 seconds. Is
there a seperate timeout setting for the method itself? I
couldn't find any other timeout settings other than the
one in the Connection object which I explicitly set.
Thanks in advance for your help.

Try the CommandTimeout on the DataAdapter's SelectCommand.

David
 
Back
Top