SqlCommand.CommandTimeout is reached

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, Jul 30 '12 at 18:36
new SqlConnection(ConfigurationManager.ConnectionStrings["MainDll"].ToString())) probably should be new SqlConnection(ConfigurationManager.ConnectionStrings["MainDll"].ConnectionString) — Mithrandir, Jul 30 '12 at 18:39
@chris : wether inside the using, or "around" the using. Both are possible. http://stackoverflow.com/questions/4590490/try-catch-using-right-syntax — Raphaël Althaus, Jul 30 '12 at 18:57

score 1 · Answer 1 · answered Jul 30 '12 at 18:39

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 '12 at 18:39

HatSoft

11,077
3
28
43

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

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 '17 at 12:02

Community

1
1

answered Jul 30 '12 at 18:51

Channs

2,091
1
15
20

SqlCommand.CommandTimeout is reached

2 Answers2