Oracle Sequence Example

Oracle > Sequence

Sequences are database objects from which multiple users can generate unique integers. The sequence generator generates sequential numbers, which can help to generate unique primary keys automatically, and to coordinate keys across multiple rows or tables.

Example:

CREATE SEQUENCE order_sequence

      INCREMENT BY 1

      START WITH 1

      NOMAXVALUE

      NOCYCLE

      CACHE 10;

INSERT INTO orders (order_no)

VALUES (order_sequence.NEXTVAL);

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

}