Connection Timeout on aSQLDataAdapter

  • Thread starter Thread starter Jeffrey Bradshaw
  • Start date Start date
J

Jeffrey Bradshaw

IS there any way to set the connection timeout on a SQLDataAdapter? I want
to fill a dataset but I can't set any way to change the timeout.

TIA.

Jeffrey
 
Hi Jeffrey:

Remember that there are two timeouts that you can deal with, the
connection's timeout property and the command's timeout property. The
connection's is read-only and can only be specified by setting it in the
connection string. The command you can set manually. You may want to
manipulate both but usually, if your connection times out, you have issues.

HTH,


Bill

www.devbuzz.com
www.knowdotnet.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataAdapter.Fill(Dataset) shows timeout error. 2
SQLAdapter Timeout doesn't work 6
Fill method ignoring CommandTimeout value 3
Connection String - how to include timeout? 5
Connect without async but get timeout error when async=true 5
Default Command Timeout Value in Framework 0
Query Timeout Expired Using SELECT/WHERE 5
Need SqlDataAdapter never to time out while running selects 2

Back
Top