Visual Studio Shortcuts

Hey friends! While coding on visual studio, I've landed to few shortcuts which proved really effective and time savvy for me. I thought to compile the same for the benefits of larger audience. Feel free to share with others as well.
 

• CTRL + k + f , CRTL + k + d: Format the code in the window into indented. CRTL + k + d format whole document while CTRL + k + f format only selected text. For VS 2008, it is CTRL+ E+ F and CTRL +E+D.

• SHIFT + Del: This one will cut the entire row from the document and paste it to the clipboard. Even no need to select the row, just put the marker there and click SHIFT + Del.

• CTRL + k + c , CTRL + k + u: These two are for commenting selected text (the "c" options) and un-commenting selected text (the "u" option).

• CTRL - , CTRL SHIFT: Moves the editing cursor to the last/next position. If you edit something somewhere else and you wanna go back to that last method you were editing. CTRL - will save you so much time!

• Alt + Enter: Is also a general Windows shortcut for accessing properties of files, drives, shortcuts, etc. It is a nice keystroke to keep in mind.

(You can also open properties window just by pressing F4. I like it more than Alt+Enter.)

• SHIFT + ALT + ENTER (Full Screen mode): It helps you to get rid of all the properties, toolbar and other [obstructives] windows that don’t let you see the code. Hit it a second time and the windows are back.

• CTRL + M + M: Expanding / Collapsing code blocks, e.g. regions/methods.

• CTRL+J: Intellisense

• CTRL + SPACE: While coding lets VS finish for you or open intellisense

• CTRL + TAB: Flips forward and backwards, between the last two accessed files.

• CTRL + SHIFT + H: Does very smart job for find and replace. Further, first do Ctrl+F for find and then just press F3 for next match. Easy!

And finally,

·CTRL + SHIFT + B: Build solution

ADO

Here's another post under the label 'Tech terms'. As always, these posts are tagged with label 'Tech terms' to be searched conveniently.

Today's term to understand is ADO:

•  Microsoft's ActiveX Data Objects (ADO) is a set of Component Object Model (COM) objects for accessing data sources

• A part of MDAC(Microsoft Data Access Components), it provides a layer between programming languages and OLE DB (a means of accessing data stores, whether they be databases or otherwise, in a uniform manner)

• ADO allows a developer to write programs that access data without knowing how the database is implemented. You must be aware of your database for connection only. No knowledge of SQL is required to access a database when using ADO, although one can use ADO to execute arbitrary SQL commands. The disadvantage of this (i.e. using SQL directly) is that it introduces a dependency upon the type of database used.

• It is positioned as a successor to Microsoft's earlier object layers for accessing data sources, including RDO (Remote Data Objects) and DAO (Data Access Objects). ADO was introduced by Microsoft in October 1996.

JET DB

With this post, I'm going to start a series to understand different tech terms. These posts are tagged with label 'Tech terms' to be search conveniently.


So let's begin with today's term which is Microsoft's JET DB:

• It stands for Microsoft Jet Database Engine

• JET stands for Joint Engine Technology

• Over the years, Jet has become almost synonymous with Microsoft Access

• The Microsoft Jet Database Engine is a database engine on which several Microsoft products were built.

• first version: 1992

• With version 2007 onwards, Access includes a new engine based on Jet, called the Microsoft Access Engine (ACE Engine). The ACE engine is fully backward-compatible with previous versions of the Jet engine, so it reads and writes (.mdb) files from earlier Access versions. The new engine introduces a new default file format, (.accdb),

• Microsoft has no plans to natively support Jet under 64-bit versions of Windows.

• The Jet Database Engine will remain 32-bit for the foreseeable future.