Pages

Friday, April 5, 2013

FIDDLER - TLS issue

FIDDLER - TLS 1.0 issue


Having trouble with opening certain HTTPS webpages when Fiddler is running in the background?
Or trying to access certain HTTPS pages using a .NET program?

http://blogs.msdn.com/b/fiddler/archive/2012/03/29/https-request-hangs-.net-application-connection-on-tls-server-name-indicator-warning.aspx

Friday, September 16, 2011

Flipping Data in Microsoft Excel

Flipping Data
Summary: How to reverse the order of rows in a table. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Taken from : http://excel.tips.net/T002653_Flipping_Data.html
---------------------------------------------------------------------------

Many people use Excel as a simple database manager, entering information in different rows of a worksheet. As you are working with your data tables, you may come across a need to reverse the order of the rows in the table. Thus, if you have a table with ten rows, the rows would go from ten to one instead of one to ten.

There is no intrinsic function in Excel that allows you to flip data in this manner. However, you can use the sorting capabilities of Excel to accomplish the same thing by following these general steps:
1.Insert a new column immediately to the left of your data table.
2.In the cells of the new column, enter the numbers 1 through however many rows there are in your table.
3.Select the rows that make up your data table.
4.Choose Sort from the Data menu. Excel displays the Sort dialog box. (Click here to see a related figure.)
5.In the Sort By drop-down list, indicate you want to sort by your newly created column.
6.Click Descending as the type of sort.
7.Click on OK. Excel reorders your data in the reverse order of what it was.

Sunday, August 28, 2011

How To: Edit Visual Studio Templates

Taken from : http://www.thecodinghumanist.com/Content/HowToEditVSTemplates.aspx
---------------------------------------------------------------------------

Every time you create a new item in a Visual Studio project you get some default text. For some it is exactly what you want. For others you find yourself consistently making the same additions/deletions. Thankfully, changing the default content in the templates is easy to do.

Steps

1.Locate the templates directory.
2.Change the template you want to change.
3.Rebuild the template cache.

Locate the templates directory.

If you installed Visual Studio in its default location, you will find all the files of interest in the following two places:
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplates
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplatesCache

Under both of these directories will be separate directories for C#, VB.NET, J#, and Web. Since every language has different templates, they are separated in their own directories. Web templates are separated, and under the web folder there are folders for the individual languages. In these directories (and in the 1033 directory that all of them have) are the templates. All the files under the ItemTemplates folder are zip files. Under the ItemTemplatesCache directory are folders that correspond to the zip files in the ItemTemplates directory. For example, in the C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplates\CSharp\1033 directory is a zip file named Class.zip. This is the template for the Class file option in the Visual Studio dialog Visual C# projects. Its twin in the cache is C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplatesCache\CSharp\1033\Class.zip, which is the files that are contained in the Class.zip file.

Find the template you want and edit it.

So next find the item template that you would like to edit. Let us say you want to edit the normal class template, the one that you get when you pick "Class" in the new item dialog in a class library. That one is found in ItemTemplates\CSharp\1033\Class.zip. Find that file, back it up somewhere (just in case something goes wrong), and extract the contents. You will probably see the following:
using System;
using System.Collections.Generic;
using System.Text;

namespace $rootnamespace$
{
    class $safeitemrootname$
    {
    }
}

I will take you through the changes I make. First, since I take them out more than I keep them in, I remove the second two using statement. Second, I put "public " in front of the class declaration. After that, I am done.

Next, delete the Class.zip in the ItemTemplates\CSharp\1033\ directory. Put the files that are in the folder that was extracted earlier into a new zip file called Class.zip, and place that new zip file where the old zip file was. At that point the edits are done.

If you were to go into Visual Studio after that and create a new class file you would notice that the changes were not yet in effect. To make that happen, you have to rebuild the template cache.


Rebuild the template cache.

It appears that Visual Studio pulls from the ItemTemplatesCache folder for its template items, not from the ItemTemplates folder. To get those changes into the ItemTemplateCache you can manually make the changes or you can have Visual Studio rebuild the template cache. This is done by opening up the Visual Studio 2005 Command Prompt and executing "devenv /installvstemplates". This will recreate the cache.

What you do not want to do is to just make the change in the ItemTemplatesCache folder and not in the ItemTemplates folder. If there is any reason in the future that the cache needs to be regenerated, all of your changes would be lost. When the cache is recreated the ItemTemplatesCache folder is deleted, so any local modifications will be lost.

Also, I would recommend shutting down Visual Studio with the rebuilding is done. Visual Studio does not need to be restarted for the change to be noticed, but it did give me an error once (sorry, do not remember what it said) when I rebuilt with Visual Studio opened, but not after I closed the IDE and ran it again.

Sunday, February 20, 2011

Sachin Tendulkar - All Centuries (Video Highlights)



TESTS

1) 14th August 1990 - 119* against England
    Old Trafford Cricket Ground, Manchester (England)



4) 28th November 1992 - 111 against South Africa
    Wanderers Stadium, Johannesburg (South Africa)



5) 12th February 1993 - 165 against England
    M.A. Chidambaram Stadium, Chennai (India)



9) 8th June 1996 - 122 against England
    Edgbaston Cricket Ground, Birmingham (England)



11) 4th January 1997 - 169 against South Africa
    Newlands Cricket Ground, Cape Town (South Africa)



22) 28th December 1999 - 116 against Australia
    Melbourne Cricket Ground, Melbourne (Australia)



38) 4th January 2008 - 169 against Australia
    Sydney Cricket Ground, Sydney (Australia)



49) 11th October 2010 - 214 against Australia
    M. Chinnaswamy Stadium, Bangalore (India)



ODIS

14) 22nd April 1998 - 143 against Australia
    Sharjah Cricket Association Stadium, Sharjah



15) 24th April 1998 - 134 against Australia
    Sharjah Cricket Association Stadium, Sharjah



19) 28th October 1998 - 134 against Australia
    Bangabandhu Stadium, Dhaka (Bangladesh)



21) 13th November 1998 - 124* against Zimbabwe
    Sharjah Cricket Association Stadium, Sharjah



37) 16th March 2004 - 141 against Pakistan
    Rawalpindi Cricket Stadium, Rawalpindi (Pakistan)

Saturday, February 19, 2011

Movie Maker Hanging - Solution

Article taken from : http://www.acomputerportal.com/movie_maker_file_fix.html

---------------------------------------------------------------------------------------------------------


Movie Maker sometimes causes problems crashing or hanging when trying to save projects or files.

(This appears to be a Hardware acceleration issue)


This is how I solved this problem:

For Windows Vista

1) Click on the Start Button.
2) Right Click on "Computer", select "Properties".
3) Click on "Advanced System Settings" on the left.
4) Click on the Advanced Tab
5) In the Performance, Visual effects. processor scheduling, memory usage, and virtual memory section:-
6) Click on the Settings Button
7) Click on the Advanced Tab on this window.
8) Within the Process scheduling section click in the Radio Button Background services
9) Then Click the Apply button, bottom right.
10) Then click the OK Button.
11) Then click the next OK Button.
12) Close the windows.


For Windows XP

1) Click on the Start Button.
2) Select My Computer
3) Select View system information
4) Click on the Advanced Tab
5) In the Performance, Visual effects. processor scheduling, memory usage, and virtual memory section:-
6) Click on the Settings Button
7) Click on the Advanced Tab on this window.
8) Within the Process scheduling section click in the Radio Button Background services
9) Then Click the Apply button, bottom right.
10) Then click the OK Button.
11) Then click the next OK Button.
12) Close the windows.

Windows Movie Maker should now handle files and projects all right.

I noticed no degrade in computer speed after using this File Fix.

Good Luck.

Another Tip. Is having patience, and then have even more patience. Video, Picture and sound files may be very large and therefore take some time to import and process etc.

Thursday, May 27, 2010

WLXQuickTimeControlHost.exe is taking up all your CPU Memory

This is in an interesting one, and can be a real killer for your computer. No, this isn’t a virus, and no, it’s not spyware. It’s an official Microsoft process that is part of the Windows Live Photo Gallery that they recently released. Apparently it still has some bugs in it such that some people will find that this process loads up mysteriously and simply hogs the CPU and chokes out any other process you want to run.

It acts like a virus, kind of, because it brings your computer to a virtual stand-still. But it’s just a buggy part of their program. And they know about it, too.

Here is an article on their knowledgebase on how to resolve this problem:

http://support.microsoft.com/kb/944563/en-us

Disable support for QuickTime

The following batch file will automatically perform all the steps that are required to disable support for QuickTime.
To create and run the batch file that will disable support for QuickTime, follow these steps:

  1. Copy the text the next section, “Batch file to disable QT support.”
  2. Paste the text into Notepad.
  3. Save the document to your desktop as “DisableWLPGQT.cmd,” and then exit Notepad.
  4. Run the batch file. To do this, follow the appropriate step:
    1. In Windows Vista, right-click the DisableWLPGQT.cmd file, and then click Run as administrator.
    2. In Windows XP, make sure that you are logged in as a user who has administrator credentials. Then, double-click the DisableWLPGQT.cmdfile.
  5. Restart the computer.

QuickTime content is now disabled in the Windows Live Photo Gallery.

Saturday, March 6, 2010

Fixing "BOOTMGR is missing" Error While Trying to Boot Windows Vista

If your Windows Vista computer has encountered the dreaded “BOOTMGR is missing” error, you aren’t alone. If the problem isn’t hardware related you can fix it with relative ease as long as you have a Windows Vista DVD handy.

If you don’t have one, you can create a Windows Vista repair disk using our guide.

image

Boot off the Windows Vista DVD and then click Next at the first prompt:

image

You should see a link in the lower left-hand side for “Repair your computer”

image

The installation process will attempt to find your Vista installation directory. If there’s more than one in the list, select the correct one and then use the Next button again.

image

Click the first link for “Startup Repair”

image

The installation process will repair the system, and then prompt for you to reboot.

image

Alternatively you could have chosen the Command Prompt option instead, and use the following command to fix the boot options only:

bootrec /fixboot

image

At this point you should be able to reboot your computer, remove the DVD and everything should be working. If not, then head over to the online forums and ask your question there. We’ve got some top-notch geeks over there!