C#

Anthony Fernando wrote:

i want some free/open source dll

Anthony Fernando wrote:

i need no dependencies too

Anil0007 wrote:

i was thinking it should completed in 5 seconds

Task t0 = Task.Factory.StartNew(() => dowork());
Task t1 = Task.Factory.StartNew(() => DoAnotherWork());

await Task.WhenAll(t0, t1);

dowork(); // this will block execution for 5s as dowork is executed on the current thread
Task.Run(() => dowork());   // the dowork will happen on its own thread and that thread will run for 5 seconds
                            // but the code in this block will continue to run so dowork is an asynchronous call
await Task.Run(() => dowork()); // a mix of both the above.  The task will still run on its own thread for
                                // 5 seconds, but execution will wait until that new thread has finished

protected async void btnSubmit_Click(object sender, EventArgs e)
{
    Response.Write(DateTime.Now.ToString("dd-MM-yyyy:hh:mm:ss") + " <br/>");
    
    Task first = dowork();
    Task second = DoAnotherWork();
    await Task.WhenAll(first, second);
    
    Response.Write(DateTime.Now.ToString("dd-MM-yyyy:hh:mm:ss") + " <br/>");
}

async Task dowork()
{
    await Task.Delay(5000);
}

async Task DoAnotherWork()
{
    await Task.Delay(3000);
}

• The update statement TABERRORINFO, the the username is concatenated into the SQL statement while all other values are passed as parameters. The username should also be a parameter
• Does the query update a row. When the ExecuteNonQUery is called, check the return value and see if it is 0 or 1 (or something else). If it's 0 there is no row to update. So the code should be something like
  
  C#

  int rowsAffected = cmd.ExecuteNonQuery();
  if (rowsAffected != 1) {
     // inform user etc...
  }
  ...

  
  
• Instead of using a single connection for all statements I'd suggest wrapping the operations inside a using block


• It looks you may store a date in a string column. If that is the case I'd suggest using a datetime data type for dates. This will remove a lot of unnecessary complexity in the code.