Var C# Example

C# > Types > Var

Var is implicitly typed.

An implicitly typed local variable is strongly typed, but 

the compiler determines the type. 


Example

// var is required because the select clause specifies an anonymous type 

var query = from prod in products

            where prod.Category == "shoes"

            select new { prod.Name, prod.Price };

// var is required because item is an anonymous type

foreach (var item in query)

{

               

}

C# Void Type Example

C# > Types > Void

Void specifies that the method doesn't return a value.

Example

private void Log(string msg)

{

   // log method

}

SQL Server Drop

SQL Server > DDL > Drop

DROP statements removes existing entities.

• DROP TABLE
• DROP TRIGGER

DateDiff Visual Basic Example

VB.NET > Functions > DateDiff

Returns a value specifying the number of time intervals 
between two dates.

Example:

Dim dt1 As Date = #3/1/2014#

Dim dt2 As Date = #4/1/2014#

MessageBox.Show("Day diff: " & DateDiff(DateInterval.Day, dt1, dt2) & " Week diff: " & DateDiff(DateInterval.Weekday, dt1, dt2))

C# Forms

C# > Forms

Contains classes for creating Windows-based applications using features available in the Microsoft Windows operating system.

• MessageBox
• PrintPreviewDialog

MessageBox C# Example

C# > Forms > MessageBox

Examples:

A. Displays a message box with specified text.

    MessageBox.Show("Text message");

B. Displays a message box with specified text, caption, and buttons.

string message = "Do you want to close this windows?";

string caption = "Question";

MessageBoxButtons buttons = MessageBoxButtons.YesNo;

DialogResult result = MessageBox.Show(message, caption, buttons);

if (result == System.Windows.Forms.DialogResult.Yes)

{

  this.Close();

}

AppActivate Visual Basic

VB.NET > Functions > AppActivate

Activates an application that is already running.

Example:
Start and activate notepad

AppActivate(Shell("C:\Windows\System32\notepad.exe", AppWinStyle.NormalFocus))