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

CurDir Visual Basic

VB.NET > Functions > CurDir 

Returns the current path.

Example:

MessageBox.Show(CurDir())

C# Random Color

C# > Color > Random

Random rnd = new Random();

Color randomColor = Color.FromArgb(rnd.Next(255), rnd.Next(255), rnd.Next(255));