Use Task To Test Database Connection

See more:

C#

C#4.0

Task

Good day all!!! I have a form where I'm entering the connection details to connect to an MSSql database. This is what I have done...

private void sbTest_Click(object sender, EventArgs e)
        {
            if (!dxvpConnectionWizard.Validate())
                return;

            TaskScheduler uiScheduler = TaskScheduler.FromCurrentSynchronizationContext();
            CancellationTokenSource tokenSource = new CancellationTokenSource();
            CancellationToken token = tokenSource.Token;

            this.Cursor = Cursors.AppStarting;

            Task connectionTestTask = Task.Factory.StartNew(() =>
            {
                bsiConnWizardStatus.Glyph = ClaimCatch_RIS.Properties.Resources.loading;
                bsiConnWizardStatus.Caption = "Attempting to connect to database...";

                using (SqlConnection connection = new SqlConnection(GetDataBaseConnectionString()))
                {
                    try
                    {
                        connection.Open();
                        connection.Close();
                    }
                    catch// (Exception ex)
                    {
                        tokenSource.Cancel(true);
                    }
                }
            }, token).ContinueWith(result =>
            {
                this.Cursor = Cursors.Default;
                
                if (token.IsCancellationRequested)
                {
                    bsiConnWizardStatus.Glyph = ClaimCatch_RIS.Properties.Resources.warning_16x16;
                    bsiConnWizardStatus.Caption = ServerModeStrings.failedDatabaseConnection;
                }
                else
                {
                    bsiConnWizardStatus.Glyph = ClaimCatch_RIS.Properties.Resources.apply_16x16;
                    bsiConnWizardStatus.Caption = "Ready...";
                }
            }, CancellationToken.None, TaskContinuationOptions.None, TaskScheduler.FromCurrentSynchronizationContext());
        }

But it's not exactly what I want. I actually want is to be able catch the error from the database and also get the task status.

How would I go about doing that...

Thanx in advance...