c# timed out exception for simple query.

Question

Im getting a time out expired.

The timeout period elapsed prior to completion of the operation.

If I execute the same query in SQL server management its getting executed but trying to execute the query through the program does not succeed.

Where could I have gone wrong?

The query is very simple and its throwing exception. The time out set is 90 sec.

Select isnull(max(voucherid),0)+1 from XXX
dbmanager.executequery(con,"uspXXX",parameter);

if you want help you need to be around to answer questions... — Mitch Wheat, Aug 06 '13 at 07:20

score 0 · Answer 1 · edited May 23 '17 at 12:23

0

Rebuild your statistics and/or indexes on that table.

See this answer.

edited May 23 '17 at 12:23

Community

answered Aug 06 '13 at 05:37

Mitch Wheat

Thanks but i tried every possible way but still the result is same is there any other suggestions that i can try,,..?? – Naveen Aug 06 '13 at 05:45
what is the size of the table? – Shaikh Farooque Aug 06 '13 at 06:23
@Shaikh Farooque : please address your comments to the original question rather than under this answer. – Mitch Wheat Aug 06 '13 at 06:27

1 Answers1