In the How to Use Advanced Updater to Configure Auto-Updates for Your Application article, you can check the process of configuring the Update functionality, using the Advanced Updater.
The Configuring auto-updates for a Windows application video shows how you can configure the Updater for a Windows application.
The How the Updater works diagram illustrates the steps of how an application is upgraded from one version to the next when using the Advanced Updater.
Sample projects can be downloaded from here.
EDIT: To automatically install updates at user logon or any other custom trigger, check the following forum thread that contains a sample project and more information on how to achive this: Install updates without elevation, automatically at user logon.