How to visit any particular line of code in Visual Studio

If there are lots of lines of code in a single code file and your colleagues told you to look piece of code at particular line number or any error occurred at specific line number.

How do you visit to that line of code?

By just scrolling ... that’s history

Solution :->

Some couple of handy ways to visit to particular line number in Visual studio

·         You can display line number at left side of code editor from Tools -> Options -> Text Editor -> All Languages -> Enabled Line numbers option. It should display line numbers in code editor as shown below

·         Visual Studio always display line number , column number and character position of cursor in status bar of visual studio as shown in above image

·         You also have facility to directly visit to any line number from Edit -> Go To... or press Ctrl + G as shown below

·         Use bookmarks to directly visit any particular line numbers

·         Use scroll bar to visit to particular line

·         Use keyboard Page Up or Page Down button

·         Use UP or DOWN arrow keys to navigate

Please leave your comments or share this tip if it’s useful for you.

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")