Finding the Version Number and Edition Information In SQL

This article from Microsoft describes the method Getting the Server Version And Edition with SQL

MSDN

FindInFiles Method in VisualStudio

While using Windows you might have came through the Search Option . Where you can give a text and force the windows to find that text in files.

These method can be used in Visual Studio C#/VB.Net

Visual Studio has a method called

My.Computer.FileSystem.FindInFiles Method

Which offers to use the method used by the windows

Example

Dim findstring As String = "and"
Dim sFileList As System.Collections.ObjectModel.ReadOnlyCollection(Of String) = My.Computer.FileSystem.FindInFiles("D:\", findstring, True, FileIO.SearchOption.SearchTopLevelOnly)

Outputs
The Files list




Arguments for the commands are
directory - Directory to be searched
containsText - Text to be searched in the documents
ignoreCase - Case dependant search or not(True/False)
searchType - SearchOption
Enumeration(SearchAllSubDirectories,SearchTopLevelOnly).
Whether to include
subfolders.Default is SearchOption.SearchTopLevelOnly. Required.

Document OutLine Window in VisualStudio

For Some Times you might have added more controls in You Windows Or Web Forms.

And You are struggling to find the what is the parent control and what is the Control Hierarchy.


Visual Studio Provides visual Representation of Controls on your form.

Document Outline helps to view the Graphic Representation of your control Hierarchy

You can see the Document Outline In Visual Studio By navigating

View Menu --> Other Windows-->Document Outline Window

Screen Shots

Enabling Mouse Wheel Scroll in VB 6.0 IDE

Normally if u work on your VB 6.0 IDE you cannot able to use the Mouse Wheel to scroll the Scroll Bar..

Originally the IDE was not supporting this method

Microsoft has released an addins to fix this issue....

Download the package from Microsoft

Installation Procedure

1.Run the Exe vb6mousewheel.exe to temp folder.

2. Now you will see 5 files

3. Locate for the VB6IDEMouseWheelAddin.dll,Now you will see 5 files

4.Copy this file to either VB installed folder or some where in windows folder

5. Register it using Click Start, click Run, type regsvr32

\VB6IDEMouseWheelAddin.dll, and then click OK.

6.Start Visual Basic 6.0.

7. Click Add-Ins, and then click Add-in Manager.

8. In the Add-in Manager list, click MouseWheel Fix.

9. Restart the IDE you can able to scroll using Mouse Wheel

Method 2:

Download install the VBScroll from here

Screenshots:

Links:

Microsoft

VBScroll