SqlCommand.CommandTimeout is reached [duplicate]

Question

Possible Duplicate:
How to catch SQLServer timeout exceptions

I have the following code:

using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MainDll"].ToString()))
{
    connection.Open();
    using (SqlCommand command = new SqlCommand(sql.ToString(), connection))
    {
        command.CommandType = CommandType.Text;
        command.CommandTimeout = 300;
        returnCode = (string)command.ExecuteScalar();
        //Dispose();
    }
}

How do I know when the timeout has been reached? I want to grab it and do something with the SQL after the timeout.

It should throw an error when it reaches the command timeout. — Brian
– Brian, Commented Jul 30, 2012 at 18:36
new SqlConnection(ConfigurationManager.ConnectionStrings["MainDll"].ToString())) probably should be new SqlConnection(ConfigurationManager.ConnectionStrings["MainDll"].ConnectionString) — Mithrandir
– Mithrandir, Commented Jul 30, 2012 at 18:39
@chris : wether inside the using, or "around" the using. Both are possible. stackoverflow.com/questions/4590490/… — Raphaël Althaus
– Raphaël Althaus, Commented Jul 30, 2012 at 18:57

HatSoft · Accepted Answer · 2012-07-30 18:39:33Z

1

You can only know the Timeout is reached when a error is thrown

So I would suggest is try to handle the exception and if TimeOut exception is caught thats the time you can do as per your requirement

answered Jul 30, 2012 at 18:39

HatSoft

11.3k3 gold badges30 silver badges43 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:02:59Z

0

try {
  //your code
}
catch (SqlException ex) {
  if (ex.Number == -2) { //System.Data.SqlClient.TdsEnums.TIMEOUT_EXPIRED
    //handle timeout
  }
  else {
    throw;
  }
}
finally {
  //cleanup
}

Source: This SO thread.

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Jul 30, 2012 at 18:51

Channs

2,1012 gold badges15 silver badges21 bronze badges

Collectives™ on Stack Overflow

SqlCommand.CommandTimeout is reached [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related