Pinter Computing – Page 68 – Knowledge Base for IT Professionals, Teachers and Astronauts

How to remove Windows 8 and install Windows 7 on a Toshiba Satellite p50-A series laptop

If you want to remove the preinstalled Windows 8 from a new Toshiba Satellite P50-AST3GX2 laptop you need a Windows 7 DVD. You can buy the Windows 7 DVD at Amazon.

The first step is to turn off UEFI in the BIOS and enable the legacy boot. This will allow the computer to boot from the Windows 7 DVD.

To enter the BIOS

Insert the Windows 7 DVD into the DVD drive
Completely turn off the laptop to access the Toshiba BIOS Setup. When you select “Shut down” on the Windows 8 screen the computer only goes to hibernation mode. To completely shut down Windows 8 follow the steps in How to completely shut down Windows 8.
Press the power button and continuously tap the F12 button to open the boot menu
In the boot menu select Enter Setup and press Enter

Turn off the UEFI boot mode in the BIOS

In the BIOS setup select the Security tab on the top of the screen
Press Enter on the Secure Boot option and select Disabled
Select the Advanced tab on the top of the screen
Press Enter on the System Configuration
Press Enter on Boot Mode and select CSM Boot

Save the BIOS settings

Press the F10 key on the keyboard
On the Exit Saving Changes window press Yes to save the changes
The computer restarts

Install Windows 7

The computer will boot from the Windows 7 DVD
Select Install, Advanced installation
Delete all partitions on the hard drive
Create one partition (Windows will create another 100MB system partition for itself)
Select the large partition as the destination of Windows 7

Windows 7 drivers

The Toshiba website contains all necessary Windows 7 drivers for this model. You can download them from
http://support.toshiba.com/support/modelHome?freeText=yd062172s

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 next time you want to start Windows 8 fast. If you really want to shut down Windows 8 completely to access the boot menu of the computer you have to jump through a few absolutely illogical hoops:

Option 1

Log into Windows 8
Press Ctrl-Alt-Del on the keyboard
In the lower right corner of the screen click the Power icon
Press the Shift key on the keyboard and select Restart (not Shut down!!!!)
On the next page select Turn off your PC

Option 2

On the Windows 8 Start screen open the Settings charm in the lower right corner
Click the Power icon
Press the Shift key on the keyboard and select Restart (not Shut down!!!)
On the next page select Turn off your PC

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 turn off UEFI in the BIOS and enable the legacy boot. This will allow the computer to boot from the Windows 7 DVD.

To enter the BIOS

Turn off the laptop
Press the power button and continuously tap the F12 button to open the boot menu
In the Other Options section of the boot menu select Setup

Turn off the UEFI boot mode in the BIOS

In the BIOS setup select Boot on the top of the screen
Press Enter on the Secure Boot option and select Disabled
Press Enter on the Load Legacy Option Rom and select Enabled
Press Enter on the Boot List Option and select Legacy

Save the BIOS settings

Select Exit on the top of the screen
Select Exit Saving Changes and press Enter
Press Enter on Yes to save the changes

The computer will automatically try to restart and displays a message that “Operating system not found”

Keep the power button pressed to force it to shut down

Boot from the Windows 7 DVD

Insert the Windows 7 DVD into the DVD drive
Start the computer with the power button and continuously tap the F12 button to open the boot menu
If there is a + sign next to the CD/DVD/CD-RD Drive option select it and press Enter
If there is no plus sign next to it turn off the computer with the power button and try to start it again while tapping the F12 key

Install Windows 7

The computer will boot from the Windows 7 DVD
Select Install, Advanced installation
Delete all partitions on the hard drive
Create one partition (Windows will create another 100MB system partition for itself)
Select the large partition as the destination of Windows 7

Enjoy the last usable Windows version.

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 the Control Panel select Ease of Access Center
Select the Make the keyboard easier to use link
In the Make it easier to type section select the Set up Sticky Keys link
In the Keyboard shortcut section uncheck Turn on Sticky Keys when SHIFT is pressed five times
In the Options section uncheck Lock modifier keys when pressed twice in a row

windows 7 disable sticky keys

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 in the BIOS and enable the legacy boot. This will allow the computer to boot from the Windows 7 DVD.

To enter the BIOS

Turn off the Sony VAIO laptop
Press the small “Assist” button between the Delete button and the display to turn on the computer and display the VAIO Care Menu
In the VAIO Care Menu select Start BIOS Setup

Turn off the UEFI boot mode in the BIOS

In the BIOS setup select Boot on the top of the screen
Press Enter on the Boot Mode option and select Legacy

Save the BIOS settings

Select Exit on the top of the screen
Select Exit Saving Changes and press Enter
Press Enter on Yes to save the changes

The computer will automatically try to restart into Windows 8

Keep the power button pressed to force it to shut down

Boot from the Windows 7 DVD

Start the computer with the “Assist” button
Insert the Windows 7 DVD into the DVD drive
In the VAIO Care Menu Menu select Start from Media (USB device/optical disc)

Install Windows 7

The computer will boot from the Windows 7 DVD
Select Install, Advanced installation
Delete all partitions on the hard drive
Create one partition (Windows will create another 100MB system partition for itself)
Select the large partition as the destination of Windows 7

Enjoy the last usable Windows version.

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 navigate to http://www.skype.com/go/getskype-full
This link will download the latest full desktop Skype application
Save the appication
When the download completed select Run to install the Skype desktop application
Log in with your regular Skype account name an password

To add the full Skype desktop application to the Windows 8.1 start screen

Click the down arrow at the lower left corner of the Start screen
The page will display all of your installed applications in alphabetical order
Scroll to the right to see the Skype for Desktop icon in the Skype section
Right click the Skype for Desktop icon
At the bottom of the page select Pin to Start
Move the Skype for Desktop application icon the desired location on your Start screen

To remove the “modern” Skype application icon from the Start screen

Right click the “modern” Skype application icon on the Start screen
At the bottom of the screen select Unpin from Start

To place the Windows 8.1 “modern” Skype icon back to the Start screen

Type Skype into the search field
Right click the Skype icon
Select Pin to Start

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 the bottom margin of the design surface outside of the visible area of the form.
A new item appears in the Misc section of the property list of the form controls (buttons, textboxes, etc): ToolTip on toolTip1
Enter the text there you want the users to see when they hover above the control.

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
- Change the Name property to reflect the purpose of the object

Select the DataSource item in the Data section and click the Add Project Data Source… link

The name is misleading. At this step we are not selecting the source of the data, we are selecting the object that describes the data row. The DataGridView will generate the columns based on the object we will select here.

To load the data from a class select Object as the Data Source Type and click Next

Select the object that describes the data row you want to display

Drag a DataGridView from the Toolbox to the form

Select the small arrow at the upper right corner of the DataGridView to open the Tasks dialog
Click the down arrow next tot the Choose Data Source list
Select the Binding Data Source that you added to the form

Click the Edit Columns link to set the visibility of the columns

To hide a column set the Visible attribute in the Appearance section to False

To load data into the DatGridView add the following code to the constructor of the form. In this example the GetUsers() method returns an array of UserView objects
```
// Load the data into the DataGridView
bindingSourceUsers.DataSource = _business.GetUsers();
```
To hide the row selector column on the left side of the data add the following to the constructor of the form. This option is not included in the property sheet of the DataGridView, so we have to set it in the code.
```
dataGridView1.RowHeadersVisible = false;
```

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 the Web.config file:

<webServices>
    <protocols>
        <add name="HttpPost"/>
        <add name="HttpGet"/>
    </protocols>
</webServices>

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 value for comparison.

Column definition:

[SecondsSinceLastVisit]  AS (datediff(second,[LastVisitDate],getdate()))

Now you can use the computed column in the C# Entity Network comparison.

site.VisitFrequencySec < site.SecondsSinceLastVisit