Ceiling Example Syntax VB.NET ASP.NET | Ceiling | Source Code

Ceiling Example Syntax VB.NET ASP.NET | Ceiling | Source Code

Summary: – Illustrates using with in VB.NET ASP.NET.



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

Quick Example
Ceiling(1.9) ‘ Returns 2

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 on Visual Basic to Cut-n-paste code into Ceiling.aspx.vb

 
Imports System
Imports System.IO
Imports System.Data
Imports System.Math
 
'********************************************************************************
' 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)
'
' 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
'
' Quick Example: Ceiling(1.9) ' Returns 2
'
'********************************************************************************
' This example is from http://idealprogrammer.com
 
 
 
Partial Class _Ceiling
    Inherits System.Web.UI.Page
 
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
 
 
        Label1.Text = "Example #1: 	Ceiling(1.32) - rounds up to closest whole number"
        Dim decNumber1 As Decimal = 1.32D
 
        TextBox1.Text = Ceiling(decNumber1) ' Returns 2
 
 
        Label2.Text = "Example #2: 	Ceiling(1.9) - rounds up to closest whole number"
        Dim douNumber2 As Double = 1.9
 
        TextBox2.Text = Ceiling(douNumber2) ' Returns 2
 
 
        Label3.Text = "Example #3: Ceiling(-1.32) - rounds up to closest whole number"
 
        Dim decNumber3 As Decimal = -1.32D
 
 
        TextBox3.Text = Ceiling(decNumber3) ' Returns -1
 
 
    End Sub
End Class

Step 2: Click on XML to Cut-n-paste code into Ceiling.aspx

< %@ Page Language="VB" AutoEventWireup="false" CodeFile="Ceiling.aspx.vb" Inherits="_Ceiling" %>
 
< !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <h1><asp:label ID="Label1" runat="server" Text="Label"></asp:label> </h1>
         <asp:textbox ID="TextBox1" runat="server"></asp:textbox><br />
          <h1><asp:label ID="Label2" runat="server" Text="Label"></asp:label> </h1>
         <asp:textbox ID="TextBox2" runat="server"></asp:textbox><br />
          <h1><asp:label ID="Label3" runat="server" Text="Label"></asp:label> </h1>
         <asp:textbox ID="TextBox3" runat="server"></asp:textbox><br />
 
 
 
    </div>
    </form>
</body>
</html>

Prerequistes:

  1. Install Visual Web Developer 2010
  2. Install SQL Server Express
  3. Download Northwind and Pubs Databases
  4. Attach Northwind Database to Databases in Sql Express
  5. Attach pubs Database to Databases in Sql Express

Notes:

  • You can build your own library of syntax examples by using same web site over and over and just add new web forms to it.

Instructions:

VB.NET ASP.NET Syntax Functions MathFunctions Ceiling
  1. Use Visual Web Developer 2010
  2. Create new web site;
    • Click File/New Web Site
    • Select ASP.NET Website Template
    • Select Visual Basic for Language
    • name of Web Site could be VBNET_ASPNET_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 Web Form Named Ceiling to MathFunctions folder
    • Right-click MathFunctions folder;
    • add new item;
    • Select Web Form
    • Check place code behind in separate file
    • Web Form name could be Ceiling
  6. Click on Visual Basic in step 1 at the top of this page to copy code into code-behind Ceiling.aspx.vb
  7. Click on XML in step 2 above to copy code into web form Ceiling.aspx
  8. Right-click on Ceiling.aspx in solution explorer and select view in browser