VB.NET Round Example – Code Sample Syntax

VB.NET Round Example – Code Sample Syntax

Purpose: – Illustrates using .

Purpose:
takes a decimal or double as input parameter1
and returns the number rounded to the specified number
of fractional decimals. If parameter 2 is not used,
result is rounded to whole number. Parameter3 specifies
rounding mode

Syntax:
1. Round(decimal)
2. Round(decimal, int32)
3. Round(decimal, mode)
4. Round(decimal, int32, mode)
5. Round(double)
6. Round(double, int32)
7. Round(double, mode)
8. Round(double, int32, mode)

Parameters Description
decimal Any valid System.Decimal data type number
double – any valid System.Double data type.
Parameter1 specifies the number to be rounded
int32 or mode 1. int32 specifies the number of fractional
digits to be returned in the result. If
there is no parameter2 or if it is mode,
the result is rounded to a whole number.
2. mode – The mode parameter controls how
value is rounded if the first decimal
digit in value is 5
mode The mode parameter controls how value
is rounded if the first decimal digit in value is 5
There are two possible modes:
1. MidpointRounding.ToEven. If the ones digit
is odd, it is changed to an even digit.
Otherwise, it is left unchanged. This is
often called rounding to nearest, or bankers
rounding. It minimizes rounding errors that
result from consistently rounding a midpoint
value in a single direction.
2. MidpointRounding.AwayFromZero. The
ones digit is always rounded up to the
next digit. This is the most popular
rounding method.

Result Data Type Description
decimal or double depends on data type
of parameter1. It is decimal, if parameter1 is
decimal. If parameter1 is double, result is double.

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

Imports System.Math
Public Class clsRound
 
    Public Sub Main()
 
 
        '********************************************************************************
        ' Purpose: takes a decimal or double as input parameter1
        ' and returns the number rounded to the specified number
        ' of fractional decimals. If parameter 2 is not used,
        ' result is rounded to whole number. Parameter3 specifies
        ' rounding mode
        '
        ' Syntax: 	1. Round(decimal)
        ' 2. Round(decimal, int32)
        ' 3. Round(decimal, mode)
        ' 4. Round(decimal, int32, mode)
        ' 5. Round(double)
        ' 6. Round(double, int32)
        ' 7. Round(double, mode)
        ' 8. Round(double, int32, mode) 
        '  
        ' Parameter1: decimal - Any valid System.Decimal data type number
        ' double - any valid System.Double data type.
        ' Parameter1 specifies the number to be rounded
        '
        ' Parameter2: int32 or mode - 1. int32 specifies the number of fractional
        ' digits to be returned in the result. If 
        ' there is no parameter2 or if it is mode,
        ' the result is rounded to a whole number.
        ' 2. mode - The mode parameter controls how 
        ' value is rounded if the first decimal 
        ' digit in value is 5
        ' 
        ' Parameter3: mode - The mode parameter controls how value 
        ' is rounded if the first decimal digit in value is 5
        ' There are two possible modes:
        ' 1. MidpointRounding.ToEven. If the one's digit 
        ' is odd, it is changed to an even digit. 
        ' Otherwise, it is left unchanged. This is 
        ' often called rounding to nearest, or banker's 
        ' rounding. It minimizes rounding errors that 
        ' result from consistently rounding a midpoint 
        ' value in a single direction.
        ' 2. MidpointRounding.AwayFromZero. The 
        ' one's digit is always rounded up to the 
        ' next digit.  This is the most popular 
        ' rounding method. 
        ' 
        ' Result: decimal or double - depends on data type
        ' of parameter1. It is decimal, if parameter1 is 
        ' decimal. If parameter1 is double, result is double.
        '
        '********************************************************************************
        ' This example is from http://idealprogrammer.com
 
        Console.WriteLine("Example #1: 	Round(decimal)")
 
        Console.WriteLine("Round(3.5) = {0}", Round(3.5)) ' Returns 4
 
        'write blank line to make output easier to read
        Console.WriteLine()
 
        Console.WriteLine("Example #2: 	Round(double, mode)")
        Dim myDouble As Double = 6.5
        Console.WriteLine("Round(myDouble, MidpointRounding.ToEven) = {0}", _
                          Round(myDouble, MidpointRounding.ToEven)) ' Returns 6
        'write blank line to make output easier to read
        Console.WriteLine()
 
        Console.WriteLine("Example #3: 	Round(double, mode)")
 
 
 
        Console.WriteLine("Round(myDouble, MidpointRounding.AwayFromZero) = {0}", _
                          Round(myDouble, MidpointRounding.AwayFromZero)) ' Returns 7
 
        '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 myclsRound As New clsRound
        myclsRound.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 Round

  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 clsRound to MathFunctions folder
    • Right-click MathFunctions folder;
    • add new item;
    • Select class
    • Class name could be clsRound
  6. Click on Visual Basic in code in step 1 above to copy code into clsRound.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