VB.NET Ceiling Example – Code Sample Syntax
VB.NET Ceiling Example – Code Sample Syntax
Purpose: – Illustrates using VB.NET Ceiling Code Example.
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.
Ceiling(decimalnumber)
Parameters | Description | decimalnumber | decimal number |
---|
Result Data Type | Description | decimal | closest whole number equal or higher |
---|
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:
- Install Visual Basic (Express or Standard Edition)
- Install SQL Server Express
- Download Northwind and pubs Database
- Attach Northwind Database to Databases in Sql Express
- 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:
- Use Visual Basic 2010 Express or Standard Edition
- Create new project;
- Click File/New Project
- Select Console Application Template
- Select Visual Basic for Language
- name of project could be VBNET_Syntax.
- Add New folder named “Functions”
- Right-click project name in solution explorer;
- add new folder;
- name of folder could be: Functions
- Add New subfolder named “MathFunctions”
- Right-click Functions folder in solution explorer;
- add new folder;
- name of folder could be: MathFunctions
- Add Class Named clsCeiling to MathFunctions folder
- Right-click MathFunctions folder;
- add new item;
- Select class
- Class name could be clsCeiling
- Click on Visual Basic in code in step 1 above to copy code into clsCeiling.vb
- Click on Visual Basic in code in step 2 above to copy code into Module1.vb
- Click green arrow or press F5 to run program