title: Send The Client a Notification after Postback ASP.NET
body: <p>I have an <code>UPDATE</code> SQL transaction that connects to a SQL Server database using C# .NET 4.0 (I'm currently using  <code>SqlCommand.ExecuteNonQuery</code> which is not Async so I'm sure I'm gonna need to change it). The transaction execution time is long (about a minute). I have ASP.NET application (Web Forms) and I wish to execute the transaction asynchronously while keeping the user able to interact with the application (navigating through pages). After the execution is finished, I wish to push kind of a notification to the user telling him that the transaction is finished.</p>
  
  <p>I realize that my problem has two parts: the ADO.NET Async part and the part of triggering the application to push a notification to the client when the transaction is complete.</p>
  
  <p>What's the best approach to implement both parts?</p>