C#

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);
        }

WaseemAmin wrote:

if the user is a common person

public class H2G2
{
  private const int Answer = 42;
  public H2G2()
  {
    Console.WriteLine("The answer to Life, the Universe, Everything is {0}", Answer);
  }
}

public class TaxCalc
{
  private readonly double taxRate;
  public TaxCalc(double taxRate)
  {
    this.taxRate = taxRate;
  }

  public void Calculate(double value)
  {
    double total = value * taxRate; // Note that taxRate cannot change now that it has been set.
      // this means you can't do something like this --taxRate;
    Console.WriteLine("The total is {0}", total);
  }
}

Pete O'Hanlon wrote:

There's a subtle difference between readonly and const which it sort of emulates. If you like, you can think of readonly as a runtime constant as opposed to const which is a compile time constant.

eng.iris wrote:

when delay button clicked i move the current record to another datatabbe and after 2 min i restore it back to the original datatable

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

Wait, what?

eng.iris wrote:

may be my idea was not good

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

eng.iris wrote:

i dont get ur idea

CREATE TABLE A (
pationt_no   BIGINT
pationt_name VARCHAR(250)
test_time    DATETIME)

CREATE TABLE B (
pationt_no   BIGINT
pationt_name VARCHAR(250)
test_time    DATETIME)

CREATE TABLE A (
pationt_no   BIGINT
pationt_name VARCHAR(250)
test_time    DATETIME
IsInTableB   BIT)

SELECT *
   FROM A
  WHERE IsInTableB = False

eng.iris wrote:

when delay button clicked i move the current record to another datatabbe and after 2 min i restore it back to the original datatable but unfortunately i get an error

"that deleted records cant be inserted " ? even if i refreshed my datasource

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]