C#

Sahyadri31 wrote:

Winners don't do different thing they do things differently.

Midnight Ahri wrote:

I tried a lot of example and still not working.

Midnight Ahri wrote:

at least tell me what is wrong in my code.

Richard MacCutchan wrote:

So you want us to guess a) what your code is doing, and b) what errors occur.

After calling OpenAsync, State must return Connecting until the returned Task is completed. Then, if the connection was successful, State must return Open. If the connection fails, State must return Closed.

this.cnn.OpenASync();

if (this.cnn.State == ConnectionState.Connecting)
{
    //cnn is busy connecting
}

if (this.cnn.State == ConnectionState.Closed)
{
    //cnn failed to open
}

static async Task<ConnectionState> Method(SqlConnection cnn)
        {
            await cnn.OpenAsync();
            return cnn.State;
        }

private void SQLClientLoader_Load(object sender, EventArgs e)
        {
            do
            {
                this.cnn = new SqlConnection(this.par.Constr);

                try
                {
                    ConnectionState cst = Method(cnn).Result;

                    if (cst == ConnectionState.Open)
                    {
                        this.par.sqSuccess = true;
                    }
                    else
                    {

                    }
                }
                catch (Exception ex)
                {
                    this.par.sqSuccess = false;

                    this.par.Exception = ex.Message;
                }
                finally
                {

                }
            } while ((bool)this.par.sqSuccess != true);
        }

private void SQLClientLoader_Load(object sender, EventArgs e)
        {
            this.GetSQLState();
        }

async private System.Threading.Tasks.Task<ConnectionState> GetStateAsync()
        {
            do
            {
                this.cts = new CancellationTokenSource();
                this.cnn = new SqlConnection(this.par.Constr);

                try
                {
                    await Task.Delay(2500);

                    await this.cnn.OpenAsync(cts.Token);
                }
                catch (Exception ex)
                {
                    cts.Cancel(false);

                    this.cnn.Dispose();
                    this.cts.Dispose();
                }
            } while (this.cnn.State != ConnectionState.Open);

            return this.cnn.State;
        }

async private void GetSQLState()
        {
            

            if (await GetStateAsync() == ConnectionState.Open)
            {
                this.Close();
            }

            await Task.Delay(2500);
        }