CDate Example Syntax VB.NET ASP.NET | CDate | Source Code
CDate Example Syntax VB.NET ASP.NET | CDate | Source Code
Summary: – Illustrates using CDate with Source Code Syntax Example in VB.NET ASP.NET.
Purpose:
Converts any valid date and time into date data type
Syntax:
CDate(expression)
CDate(expression)
Parameters | Description | expression | any valid representation of date and time |
---|
Result Data Type | Description | date | returns date |
---|
Quick Example | Dim date1 As Date = CDate(“September 12, 2011”) TextBox1.Text = date1 Returns 9/12/2011 12:00:00 AM |
---|
Step 1: Click on Visual Basic to Cut-n-paste code into CDate.aspx.vb
Imports System Imports System.IO Imports System.Data '**************************************************************************************** ' Purpose: Converts any valid date and time into date data type ' ' Syntax: CDate(expression) ' ' Parameter1: expression - any valid representation of date and time ' ' Result: date - returns date ' ' Quick Example: Dim date1 As Date = CDate("September 12, 2011") ' TextBox1.Text = date1 ' Returns 9/12/2011 12:00:00 AM ' ' '**************************************************************************************** ' This example is from http://idealprogrammer.com ' It shows how you can use CDate syntax in VB.NET ASP.NET Partial Class _CDate 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: CDate(expression) " Dim date1 As Date = CDate("September 12, 2011") TextBox1.Text = date1 ' Returns 9/12/2011 12:00:00 AM Label2.Text = "Example #2: CDate(expression) " Dim date2 As Date = CDate("3:08:40 PM") TextBox2.Text = date2 ' Returns 1/1/0001 3:08:40 PM Label3.Text = "Example #3: CDate(expression)" Dim date3 As Date = CDate("September 12, 2011 3:08:40 PM") TextBox3.Text = date3 ' Returns September 12, 2011 3:08:40 PM End Sub End Class |
Step 2: Click on XML to Cut-n-paste code into CDate.aspx
< %@ Page Language="VB" AutoEventWireup="false" CodeFile="CDate.aspx.vb" Inherits="_CDate" %> < !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:
- Install Visual Web Developer 2010
- Install SQL Server Express
- Download Northwind and Pubs Databases
- Attach Northwind Database to Databases in Sql Express
- 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:
- Use Visual Web Developer 2010
- 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.
- 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 “ConversionFunctions”
- Right-click Functions folder in solution explorer;
- add new folder;
- name of folder could be: ConversionFunctions
- Add New subfolder named “TypeConversionFunctions”
- Right-click ConversionFunctions folder in solution explorer;
- add new folder;
- name of folder could be: TypeConversionFunctions
- Add Web Form Named CDate to TypeConversionFunctions folder
- Right-click TypeConversionFunctions folder;
- add new item;
- Select Web Form
- Check place code behind in separate file
- Web Form name could be CDate
- Click on Visual Basic in step 1 at the top of this page to copy code into code-behind CDate.aspx.vb
- Click on XML in step 2 above to copy code into web form CDate.aspx
- Right-click on CDate.aspx in solution explorer and select view in browser