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…
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…
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…
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…
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…
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…
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 -…
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…
The Entity Framework provider … could not be loaded
When you create a new Microsoft Visual Studio 2013 project that uses the Entity Framework you may get the following error message: The Entity Framework provider type ‘System.Data.Entity.SqlServer.SqlProviderServices,…
How to migrate the Visual Studio 2013 user database to SQL Server 2008
When you create a new web application in Microsoft Visual Studio 2013 the user database it creates is version 706. SQL Server 2008 can only open databases up to version 663 or earlier. To migrate the new Visual Studio 2013 databases to SQL Server 2008…