Leuck Blog

A compilation of Windows topics and other stuff

Navigate between screens (forms) in Visual Basic

clock May 9, 2009 16:22 by author Paul

To navigate or go between screens using Visual Basic simply use formName.Show()
Replace fromName with the name of your form. This will open the form specified.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5


SQL Date Format Types

clock April 23, 2009 11:07 by author Paul
SQL provides a number of different date formatting options. Use getdate() to get the date
then convert to a string and format as desired.

Number:  SQL Query:                                          Sample: 
1             select convert(varchar, getdate(), 1)      12/28/09 
2             select convert(varchar, getdate(), 2)      09.12.28 
3             select convert(varchar, getdate(), 3)      28/12/09 
4             select convert(varchar, getdate(), 4)      28.12.09 
5             select convert(varchar, getdate(), 5)      28-12-09 
6             select convert(varchar, getdate(), 6)      28 Dec 09 
7             select convert(varchar, getdate(), 7)      Dec 28, 09 
10           select convert(varchar, getdate(), 10)    12-28-09 
11           select convert(varchar, getdate(), 11)    09/12/28 
101         select convert(varchar, getdate(), 101)   12/28/2009 
102         select convert(varchar, getdate(), 102)   2009.12.28 
103         select convert(varchar, getdate(), 103)   28/12/2009  
105         select convert(varchar, getdate(), 105)   28-12-2009 
107         select convert(varchar, getdate(), 107)   Dec 28, 2009 
110         select convert(varchar, getdate(), 110)   12-28-2009 
111         select convert(varchar, getdate(), 111)   2009/12/28
Other variations are also available.

Keep in mind you need to do any calculations before you convert to string.

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5


Category list

Sign in