Timeout expired when trying to update records. C#, SQL

Question

5.00/5 (1 vote)

See more:

I tried searching for this particular answer but with no successful results and this is my last hope.

I am having a timeout error when updating 516rows in a table, but when the table only has 56 rows in it, it updates each row successfully, but when there is 516 rows returned to be updated and i loop through the first row and try and update it, i get the following error

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Note, when the table consist of only 56 it works fine.

I tried setting the commandTimeOut to 0 and 100 but nothing seems to work

Can anyone advice me on what to do?

Posted 16-Dec-09 21:44pm

Renaldob

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2009-12-16T22:11:00

Solution 1

Increase the connection timeout period !

Posted 16-Dec-09 22:11pm

Abhinav S

N a v a n e e t h · Answer 2 · 2009-12-17T17:20:00

Solution 2

Looks like you are opening the connection at the beginning and closing it after executing all 516 records. Don't do it. Open and close the connection in each iteration.

Posted 17-Dec-09 17:20pm

N a v a n e e t h

Aman Bhullar · Answer 3 · 2009-12-17T18:19:00

Solution 3

wrote:
Note, when the table consist of only 56 it works fine.

Try update command with some conditions

wrote:
I tried setting the commandTimeOut to 0 and 100 but nothing seems to work

100 is too less time.
Try using value : 40000

Posted 17-Dec-09 18:19pm

Aman Bhullar

Renaldob · Answer 4 · 2009-12-17T19:28:00

Solution 4

Looks like you are opening the connection at the beginning and closing it after executing all 516 records. Don't do it. Open and close the connection in each iteration.

I would of thought this would effect performance, but if nothing else works this would probably do the trick.

Thanks

Posted 17-Dec-09 19:28pm

Renaldob