C#

private void StartLoader(object sender, DoWorkEventArgs e)
        {
            for (int i = 1; i <= 10; i++)
            {
                if (this.par.sqSuccess) //if no error, means connection is available, stop looping
                {
                    break;
                }
                else
                {
                    i -= 1;
                }

                System.Threading.Thread.Sleep(5000); //report progress every 5 second
            }

this.cnn = new SqlConnection(this.par.Constr);

try
{
    this.cnn.Open(); //SqlConnection

    this.par.sqSuccess = true; //if no error, then I change this variable
}
catch (Exception ex)
{
    this.par.Exception = ex.Message;
}
finally
{
    if (this.cnn != null) { this.cnn.Dispose(); }
}
if (this.par.sqSuccess) { this.Close(); }