VB.NET Ceiling Example – Code Sample Syntax

VB.NET Ceiling Example – Code Sample Syntax

Purpose: – Illustrates using .

Purpose:
takes a decimal or double number and returns a value
that represents the next equal or higher whole number.
Although the result is a whole number, it is returned as a
the same data type that was passed in. Math.Floor is different
in that it rounds down to the next whole number that is equal
or less than the number that is given.

Syntax:
Ceiling(decimalnumber)

Parameters Description
decimalnumber decimal number

Result Data Type Description
decimal closest whole number equal or higher

Syntax2:
Ceiling(doublenumber)

Parameters Description
doublenumber double precision floating point number

Result Data Type Description
double precision floating point number closest whole number equal or higher

Step 1: Click Visual Basic to Cut-n-paste code into clsCeiling.vb

Imports System.Math
Public Class clsCeiling
 
    Public Sub Main()
 
 
        '********************************************************************************
        ' Purpose: takes a decimal or double number and returns a value 
        ' that represents the next equal or higher whole number.  
        ' Although the result is a whole number, it is returned as a
        ' the same data type that was passed in.  Math.Floor is different 
        ' in that it rounds down to the next whole number that is equal 
        ' or less than the number that is given.
        ' 
        ' Range: Any valid decimal or double number
        ' 
        ' Syntax: 	Ceiling(decimalnumber)
        '
        ' Parameter1: decimalnumber - decimal number
        '
        ' Result: decimal - closest whole number equal or higher
        '
        ' Syntax2: 	Ceiling(doublenumber)
        '
        ' Parameter1: doublenumber - double  precision floating point number
        '
        ' Result: double precision floating point number - closest whole number equal or higher
        '
        '  
        '********************************************************************************
        ' This example is from http://idealprogrammer.com
 
        Console.WriteLine("Example #1: 	Ceiling(expression) - rounds up to closest whole number")
        Dim decNumber1 As Decimal = 1.32D
        Console.WriteLine(Ceiling(decNumber1)) ' Returns 2
 
        'write blank line to make output easier to read
        Console.WriteLine()
        Dim douNumber2 As Double = 1.9
        Console.WriteLine("Example #2: 	Ceiling(expression) - rounds up to closest whole number")
 
        Console.WriteLine(Ceiling(douNumber2)) ' Returns 2
        'write blank line to make output easier to read
        Console.WriteLine()
 
        Console.WriteLine("Example #3: Ceiling(expression) - rounds up to closest whole number")
 
        Dim decNumber3 As Decimal = -1.32D
 
        Console.WriteLine(Ceiling(decNumber3)) ' Returns -1
 
        Console.WriteLine("Example #4: 	Floor(expression) - rounds down to closest whole number")
        Dim decNumber4 As Decimal = 1.32D
        Console.WriteLine(Floor(decNumber4)) ' Returns 1
 
        'write blank line to make output easier to read
        Console.WriteLine()
        Dim douNumber5 As Double = 1.9
        Console.WriteLine("Example #5: 	Floor(expression) - rounds down to closest whole number")
 
        Console.WriteLine(Floor(douNumber5)) ' Returns 2
        'write blank line to make output easier to read
        Console.WriteLine()
 
        Console.WriteLine("Example #6: 	Floor(expression) - rounds down to closest whole number")
 
        Dim decNumber6 As Decimal = -1.32D
 
        Console.WriteLine(Floor(decNumber3)) ' Returns -2
 
        'Prevent console from closing before you press enter
        Console.ReadLine()
 
    End Sub
 
End Class

Step 2: Click Visual Basic to Cut-n-paste code into Module1.vb

Module Module1
 
    Sub Main()
 
 
        Dim myclsCeiling As New clsCeiling
        myclsCeiling.Main()
 
 
 
    End Sub
 
End Module

Prerequistes:

  1. Install Visual Basic (Express or Standard Edition)
  2. Install SQL Server Express
  3. Download Northwind and pubs Database
  4. Attach Northwind Database to Databases in Sql Express
  5. Attach pubs Database to Databases in Sql Express

Notes:

  • Console Application is used to simplify things, but Windows Forms or Web Forms could also be used
  • You can build a library of syntax examples by using same project over and over and just commenting out what you do not want to execute in Module1.vb

Instructions:
VB.NET Syntax Functions Ceiling

  1. Use Visual Basic 2010 Express or Standard Edition
  2. Create new project;
    • Click File/New Project
    • Select Console Application Template
    • Select Visual Basic for Language
    • name of project could be VBNET_Syntax.
  3. Add New folder named “Functions”
    • Right-click project name in solution explorer;
    • add new folder;
    • name of folder could be: Functions
  4. Add New subfolder named “MathFunctions”
    • Right-click Functions folder in solution explorer;
    • add new folder;
    • name of folder could be: MathFunctions
  5. Add Class Named clsCeiling to MathFunctions folder
    • Right-click MathFunctions folder;
    • add new item;
    • Select class
    • Class name could be clsCeiling
  6. Click on Visual Basic in code in step 1 above to copy code into clsCeiling.vb
  7. Click on Visual Basic in code in step 2 above to copy code into Module1.vb
  8. Click green arrow or press F5 to run program