How to get distinct values from column in Excel

If you have repetitive entries in excel column as below

How to get distinct values from column in Excel sheet.

Solution:-

Select column and click on Data -> Remove Duplicates

You should get output as below

Please leave your comment if it’s useful for you.

How to show more than 10 projects in Visual Studio recent project list

During working in Visual Studio (VS), we can view most recently used project in "Recent Projects" list.

However VS shows only 10 recent projects.

If we are working on multiple projects then how to show more than 10 projects in recent project list?

Solution:-

Open Visual Studio -> Go to Tools -> Options -> General -> modify value of "items shown in recently used lists".

Generally I make it 20.

Please leave your comments if it’s useful for you.

A mirror that can read your mind

A mirror that can read your mind

http://www.techgig.com/tech-news/editors-pick/Beware-this-mirror-can-read-your-mind-18994

Maximum request length exceeded

If you are getting error in Asp.Net as “System.Web.HttpException: Maximum request length exceeded” This type of error mostly occurred when we are using File Upload functionality.

Due to increase in content lenth of request from the its dafult value then ASP.NET engine fires this error.

Solution: -

Open web.config file and set “maxRequestLength” key to more than the size of file.

The default size of “maxRequestLength” is 4096 KB (4 MB).

Value must be specified in KB as below

<httpRuntime maxRequestLength="10240"></httpRuntime>

10240 means 10 MB. (10 x 1024) - You can increase this up to 4 GB.

Your face is the new credit card

Are you tired to keep debit, credit cards or cash, to remembers hundreds of passwords and PIN then here is a good news. Now you don't need to remember anything. 

Please read more fro below link.

http://www.techgig.com/tech-news/editors-pick/Your-face-is-the-new-credit-card-18979

'Selected' is not a member of 'System.Windows.Forms.TreeNode'.

During migration from VB to VB.NET if you are getting error as "'Selected' is not a member of 'System.Windows.Forms.TreeNode'." with following type of code

  

'UPGRADE_ISSUE:Node property myTreeView.Nodes.Selected was not upgraded.

myTreeView.Nodes.Item("Item1").Selected = True

Solution: -

Use “SelectedNode” property to show child node as selected as below

myTreeView.SelectedNode = myTreeView.Nodes.Item(("Item1")

'MSCOMCTL.OCX' cound not be loadded--Continue Loading Project?

If you are getting error as "'MSCOMCTL.OCX' cound not be loadded--Continue Loading Project?"

Solution: -

It simply means that system don’t have file “'MSCOMCTL.OCX”. To fix this error follow below steps

·         Download and install VisualBasic6-KB896559-v1-ENU.exe from http://www.microsoft.com/en-in/download/details.aspx?id=10019

·         You need to restart system

·         Run following command to register MSCOMCTL.OCX component

o    regsvr32  C:\Windows\System32\MSCOMCTL.OCX