SqlCommand CommandTimeout property

Question

i have developed a web application asp.net C#.

on a button click i am connecting to the database which takes long time to execute. initially it use to timeout. now i increased the commondtimeout property ,

cmd.CommandTimeout = 500;

basically it processing of paygroups. time required depends on num of employess in that paygroup.

so my question is if 1 of paygroup requires less time to execute say 2 or 3 mins, will the connection sill be open for specified time in commandtimeout property?

if yes . can we estimate the processing time and set the time accordingly .

but why do you want to set lesser time? set the upper bound only — Shoaib Shaikh
– Shoaib Shaikh, Commented Apr 4, 2012 at 5:59
CommandTimeout is an upper threshold - if the command completes in less time, any synchronous code will continue as soon as the command completes. — StuartLC
– StuartLC, Commented Apr 4, 2012 at 6:10

Pranay Rana · Accepted Answer · 2012-04-04 06:01:32Z

2

why dont you try out something like this

using (SqlConnection cn = new SqlConnection(connectionString)) 
{
  //your codee to perform database operation
}

this will close your connection once your work get completed.

answered Apr 4, 2012 at 6:01

Pranay Rana

177k37 gold badges244 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pranay Rana Over a year ago

@kumarchaudhari - you can set the value there no issue in it but it remain for this scop only..

Pankaj · Accepted Answer · 2012-04-04 07:31:26Z

0

In Order to let the Query execute completely, Set the CommandTimeOut = 0.
Why It is taking so much time? Your transaction should be quick enough to let other query execute in time.
SQL Profiler can help you optimize your database queries. I assume you are using SQL Server

answered Apr 4, 2012 at 7:31

Pankaj

10.2k40 gold badges152 silver badges298 bronze badges

Collectives™ on Stack Overflow

SqlCommand CommandTimeout property

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related