C#

public async Task SomeFunc()
{
	await Task.Run(() =>
	{
		// Some Sync method calls here like..
		var reader = com.ExecuteReader();
		...
	}

}
 
// Or

public async Task SomeFunc()
{
	// Some Async method calls here like..
	var reader = await com.ExecuteReaderAsync();
	....
}

protected void updateSal_Click(object sender, EventArgs e)
        {
            newTotal.Text = theLinq.Salary.Single(s => s.Salary_Year == DateTime.Now.Year).Total_Salary.ToString();
        }

Protected Sub updateSal_Click(ByVal sender As Object, ByVal e As EventArgs)
    Dim rowsAffected As Integer
    Dim currYear As Integer = Date.Now.Year
        Using con As New SqlConnection("server=.;database=Test;integrated security=true")
     Using cmd As New SqlCommand("UPDATE Salary Set  Total_Salary=@totsal WHERE Salary_Year = @currentYear", con)
           cmd.Parameters.Add("@totsal", SqlDbType.Decimal).Value = newTotal.Text
           cmd.Parameters.Add("@currentYear", SqlDbType.Integer).Value = currYear
           con.Open()
           rowsAffected = cmd.ExecuteNonQuery()
        End Using
       End Using
 End Sub