My Personal Blog's
VB.NET Date Time Format Patterns
Standard Format Example List:
| Format | Code | Result |
| MM/dd/yyyy | Date.Now().ToString(“d”) | 1/15/2010 |
| dddd, dd MMMM yyyy | Date.Now().ToString(“D”) | Friday, January 15, 2010 |
| dddd, dd MMMM yyyy hh:mm tt | Date.Now().ToString(“f”) | Friday, January 15, 2010 11:06 AM |
| dddd, dd MMMM yyyy HH:mm:ss | Date.Now().ToString(“F”) | Friday, January 15, 2010 11:06:46 AM |
| MM/dd/yyyy h:mm tt | Date.Now().ToString(“g”) | 1/15/2010 11:06 AM |
| MM/dd/yyyy HH:mm:ss | Date.Now().ToString(“G”) | 1/15/2010 11:06:46 AM |
| MMMM dd | Date.Now().ToString(“m”) | January 15 |
| dd MMM yyyy HH’:'mm’:'ss ‘GMT’ | Date.Now().ToString(“r”) | Fri, 15 Jan 2010 11:06:46 GMT |
| yyyy’-'MM’-'dd’T'HH’:'mm’:'ss | Date.Now().ToString(“s”) | 2010-01-15T11:06:46 |
| yyyy’-'MM’-'dd HH’:'mm’:'ss’Z’ | Date.Now().ToString(“u”) | 2010-01-15 11:06:46Z |
| dddd, MMMM dd yyyy HH:mm:ss | Date.Now().ToString(“U”) | Friday, January 15, 2010 3:06:46 AM |
| yyyy MMMM | Date.Now().ToString(“y”) | January, 2010 |
Custom Format Examples List:
| DayFormat Value | Sample header |
| d | day of the month 1 – 31 |
| dd | day of the month 01 – 31 |
| ddd |
abbreviated name of the day of the week (Mon, Tues, Wed etc) |
| dddd |
Full name of the day of the week (Monday, Tuesday etc) |
| h | 12-hour clock hour (e.g. 9) |
| hh | 12-hour clock, with a leading 0 (e.g. 09) |
| H | 24-hour clock hour (e.g. 19) |
| HH |
24-hour clock hour, with a leading 0 (e.g. 19) |
| t | Abbreviated AM / PM (e.g. A or P) |
| tt | AM / PM |
| y |
Year. eg. 2009 become 9 |
| yy | Year. eg. 2009 become 09 |
| yyy | Year. 2009 |
| yyyy | Year. 2009 |
| K |
Represents the time zone information eg. +6:00 |
| ss |
Seconds with leading zero |
| m | Minutes |
| mm | Minutes with a leading zero |
| M |
Month number 1-12 |
| MM | Month number with leading zero 01-12 |
| MMM | Abbreviated Month Name (Jan, Feb) |
| MMMM | Full month name (January) |
| s | Seconds |
| ss |
Seconds with leading zero |
No comments yet.
No trackbacks yet.
VB.NET – ASP.NET communication between user control and web page using event handler
April 21, 2011 - 5:09 pm
Tags: ascx, ASP.NET, Event Driven Communication, event handler, eventargs, EventHandler, handler, handles, raise event, raiseevent, user control, VB.NET, VB.NET - ASP.NET communication between user control and web page using event handler
Posted in ASP.NET | No comments
In this post, we want to show how button in user control communicate with web page in asp.net First create user control called button.ascx. Add 3 button, name it btnSave, btnEdit and btnCancel. in button.ascx back code, add this code: Public Partial Class button Inherits System.Web.UI.UserControl Public Event btnSaveHandler As System.EventHandler Public Event btnEditHandler As [...]
Get first day of the month and last day of the month in VB.NET
June 3, 2010 - 4:31 pm
Tags: Finding the first and last day of the month, first day of the month, Get first day of the month and last day of the month in VB.NET, last day of the month, VB.NET
Posted in VB.NET | 1 comment
This code show how to get first date of the month and last day of the month date. Private Function GetFirstDayOfMonth(ByVal dtDate As DateTime) As DateTime Dim dtFrom As DateTime = dtDate dtFrom = dtFrom.AddDays(-(dtFrom.Day – 1)) Return dtFrom End Function Private Function GetLastDayOfMonth(ByVal dtDate As DateTime) As DateTime Dim dtTo As New DateTime(dtDate.Year, dtDate.Month, [...]
VB.NET Set Data Table to CSV File
June 3, 2010 - 4:22 pm
Tags: Data Table to CSV, datatable 2 csv, DataTable to CSV, Set Data Table to CSV File, VB.NET, VB.NET Set Data Table to CSV File
Posted in VB.NET | 1 comment
This function show how to Convert DataTable to CSV File Sub SetDataTable_To_CSV(ByVal dtable As DataTable, ByVal path_filename As String, ByVal sep_char As String) Dim writer As System.IO.StreamWriter Try writer = New System.IO.StreamWriter(path_filename) Dim _sep As String = "" Dim builder As New System.Text.StringBuilder For Each col As DataColumn In dtable.Columns builder.Append(_sep).Append(col.ColumnName) _sep = sep_char Next [...]
VB.NET: How to implement Group By in DataSet using LINQ
December 10, 2009 - 11:45 am
Tags: How to implement Group By in DataSet, implement Group By in DataSet, LINQ, VB.NET, VB.NET: How to implement Group By in DataSet using LINQ
Posted in LINQ, VB.NET | No comments
In this post I will show you the power of LINQ. At first I never try LINQ even when I developing project using Visual Studio 2008. But since I have no way to find a solution to one of my project, I start to explore LINQ which is give me a thought of how powerful [...]
Connecting asp.net to Sql server 2005 stored procedures into dataset
June 10, 2009 - 7:20 am
Tags: asp.net using dataset call stored procedures, call sql server stored procedure, dataset, SqlDataReader, stored procedures, stored procedures to dataset, using asp.net to call sql server stored procedure, VB.NET
Posted in VB.NET | No comments
This article demonstrates how to use ASP.NET and ADO.NET with Visual Basic .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. 1 step create store procedure Create Procedure GetAuthorsByLastName1 (@au_lname varchar(40), @RowCount int output) as select * from authors where au_lname like @au_lname; /* [...]
Sending Email by your own Gmail account + Attachment using ASP.NET 2.0 and VB.NET
June 6, 2009 - 6:28 pm
Tags: ASP.NET, sending email, sending email by gmail account using asp.net, sending email using asp.net, sending email with attachment, sending email with attachment by gmail account, sending email with attachment using asp.net, VB.NET
Posted in VB.NET | 1 comment
First of all, you need need to set something in your gmail account to enable sending email using asp.net 1. Open you gmail account and go to setting 2. Click on Forwarding and POP/IMAP 3. Choose Enable POP for mail that arrives from now on 4. Click save changes Here is the code for sending [...]
Read Excel Cell Value from ASP.NET 2008 – VB.NET
June 4, 2009 - 1:07 am
Tags: ASP.NET, asp.net read excel value, how to read an excel cel value, import excel from asp.net, Read Excel cell value, VB.NET
Posted in VB.NET | No comments
In this article I will show how to read value from excel per cell, First Im using FileUpload component from asp.net <td> <asp:FileUpload ID="uplFile" runat="server" Width="367px"/> </td> Don’t Forget to add triger to set autopostback, or else some people may counter error when the want to get the file name after they click browse button. [...]
SQL Server Management Objects with VB.net
May 23, 2009 - 2:40 pm
Tags: sql server 2005, SQL Server Management Objects, SQL SMO, VB.NET
Posted in VB.NET | 1 comment
SQL Server™ Management Objects (SMO) offer developers a robust toolset for operations such as backing up and restoring databases, and issuing Data Definition Language (DDL) commands. Using SQL SMO you can also connect to SQL Server, iterate through a collection of database objects and perform a variety of tasks against them. I have been created [...]
