How to jump back into a Try Catch after a Query Timeout occurs?

Question

Our servers are notoriously slow executing SQL Queries, especially at the end of each month. I have the following Try .. Catch:

Obviously it will not compile because the label is out of scope. Is there ANY way to return back to the line that cause the Timeout Error? Usually, the Server executes the 2nd try fine.

Try
{

               cmd = new SqlCommand("SELECT DISTINCT [Order Number] FROM OPERATIONS_BY_WORKCENTER WHERE LTRIM(RTRIM([Item   Number 2nd Kit])) = '" + sPartNumber + "'", myConnection2);
RetryQuery:    dr = cmd.ExecuteReader();

}
catch (Exception ex)

{
    if( ex.Message.ToUpper().Contains("Timeout")) goto RetryQuery;
}

Answer 1

use a while loop

var success = false;
while (!success)
{
   try
   {
      cmd = new SqlCommand("SELECT DISTINCT [Order Number] FROM OPERATIONS_BY_WORKCENTER WHERE LTRIM(RTRIM([Item   Number 2nd Kit])) = '" + sPartNumber + "'", myConnection2);
      dr = cmd.ExecuteReader();
      success = true;
   }
   catch (Exception ex)
   {
      if (!ex.Message.ToUpper().Contains("Timeout")) throw ex;
   }
}

you can also use the polly library:

http://www.thepollyproject.org