How to completely shut down a Windows 8 computer

As I found out the hard way when you select “Shut down” on the Power icon in the lower right corner of the Windows 8 screen the computer does not really shut down, it only goes to hibernation mode. This cheat is the trick behind the “fast boot” of Windows 8. This is great if …

How to remove Windows 8 and install Windows 7 on a Dell inspiron 7000 series laptop

If you want to remove the preinstalled Windows 8 from a new Dell inspiron 7000 series (7537) laptop you need an external USB DVD drive and a Windows 7 DVD. You can buy the LG external USB DVD drive for $40 at Best Buy, and the Windows 7 at Amazon. The first step is to …

How to disable Sticky Keys in Windows

When you press the Shift key five times Windows turns on a feature called Sticky Keys to help people to type with one hand. Sometimes this can cause inconvenience when you want to use two hands and just pressed the Shift key too many times. To turn off this automatic feature in Windows 7 In …

How to remove Windows 8 and install Windows 7 on a Sony VAIO SVF15N17CXB laptop

If you want to remove the preinstalled Windows 8 from a new Sony VAIO laptop you need an external USB DVD drive and a Windows 7 DVD. You can buy the LG external USB DVD drive for $40 at Best Buy, and the Windows 7 at Amazon. The first step is to turn off UEFI …

How to use your Skype account in Windows 8.1

When you click the Skype tile on the Windows 8.1 start screen the “modern” Skype application opens. It forces you to abandon your Skype user name and password and use a Microsoft account to log in. There is a way to use the regular Skype desktop application on Windows 8.1 Open the web browser and …

How to add tooltip to a Windows Form

In Windows Form applications the tooltip functionality is not built into the controls as in HTML objects. To add tooltip to your controls on Windows Forms Open the Windows Form in the designer Drag the ToolTip control from the Common Controls section of the Toolbox to the form. The ToolTip control will be placed at …

How to add a DataGridView to a Windows Form

To display data in a DataGridView on a Windows Form Add a new form to the Win Form Application project Drag a BindingSource from the Toolbox to the form   The bindingSource object appears below the form   Rename the Binding Source Select the bindingSource1 object below the form Press F4 to display the Properties …

How to test SOAP web services from outside of the server with a web browser

SOAP web services that accept primitive type arguments (string, int, etc.) can be tested from a web browser. For security reasons this feature is disabled if the web browser runs on another machine. To enable testing the SOAP web services in the test environment from another machine add the following to the system.web section of …

DbArithmeticExpression arguments must have a numeric common type

The Microsoft Visual Studio 2013 Entity Framework database query does not support the subtraction of two dates to calculate TimeSpan. For example the following statement will throw a runtime error: site.VisitFrequencySec < ((TimeSpan)(dtNow – site.LastVisitDate)).TotalSeconds) To solve the problem create a computed database column to calculate the difference between the dates and use the computed …

The underlying provider failed on Open

When you get the following error message in Microsoft Visual Studio 2013 check the inner exception. System.Data.Entity.Core.EntityException was unhandled   HResult=-2146233087   Message=The underlying provider failed on Open.   Source=EntityFramework The inner exception gives you detailed information on the real cause of the error. Most of the time the inner exception is the following: InnerException: …