My Personal Blog's
admin
This user hasn't shared any biographical information
Posts by admin
Marina Bay Sands Singapore
May 1, 2010 - 9:29 am
Tags: Marina Bay, Marina Bay Sands, Marina Bay Sands Singapore, Sands, Singapore
Posted in My Photo Fun | No comments
Its Saturday morning, I took this picture at 6am. Marina Bay Sands 95% completed.
Amazon.com Widgets
How to set command Timeout for getData() in TableAdapter
February 4, 2010 - 11:26 am
Tags: Accesing CommandTimeout properties in a TableAdapter, CommandTimeout property, dataset, How to set command Timeout for getData in TableAdapter, set commandTimeout in TableAdapter, TableAdapter, xsd
Posted in VB.NET | 1 comment
One of the disadvantages when we using tableadapter to retrieve the data from database is they do not provide property to set command timeout (SHIT). This giving me a huge headache for my project which most of the entire project is using tableadapter instead of creating my own DAL or class.
After do some research on [...]
VB.NET Date Time Format Patterns
January 15, 2010 - 10:00 am
Tags: Date Time Format Patterns, datetime format, datetime format patterns, VB.NET, VB.NET Date Time Format Patterns
Posted in VB.NET | No comments
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 [...]
How to format date time in SQL? – SQL Server Date Time Format
January 15, 2010 - 9:08 am
Tags: sql date format, SQL Datetime format, SQL Server Date Time Format
Posted in SQL Server | No comments
getdate() = Jan 14 2010 10:00:05:190PM
Format
Query
Result
USA mm/dd/yy
select convert(varchar, getdate(), 1)
01/14/10
ANSI yy.mm.dd
select convert(varchar, getdate(), 2)
10.01.14
British/French dd/mm/yy
select convert(varchar, getdate(), 3)
14/01/10
German dd.mm.yy
select convert(varchar, getdate(), 4)
14.01.10
Italian dd-mm-yy
select convert(varchar, getdate(), 5)
14-01-10
dd mon yy
select convert(varchar, getdate(), 6)
14 Jan 10
Mon dd, yy
select convert(varchar, getdate(), 7)
Jan 14, 10
HH:MI:SS
select convert(varchar, getdate(), 8 )
21:54:31
Mon dd yyyy H:MI:SS:msAM/PM
select convert(varchar, [...]
Chinese Garden Singapore January 01 / 2009
January 2, 2010 - 6:48 pm
Tags: 450D, canon, Chinese garden, japanese garden, Singapore
Posted in My Photo Fun | No comments
These are a view photo that I took from my Canon 450D. The location of this is Chinese garden in Singapore. I must say, it is very beautiful park they got in there. Is not only Chinese garden, but there is also Japanese garden.
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 and simple it become when doing a coding using LINQ.
SSIS: Update data from different table if data is Null
November 30, 2009 - 1:10 pm
Tags: Data Flow Task, Lookup transformation, OLE DB Command transformation, Ole DB Connection, OLE DB Source, SSIS, SSIS: Update data from different table if data is Null, Update data from different table if data is Null
Posted in SQL Server, SSIS, VB.NET | 2 comments
SSIS: SSIS stands for SQL Server Integration Services. It is the new data transformation standard for SQL Server 2005 and has replaced the old SQL Server Data Transformation Services.
In this post, I want to show how to update data from different table with condition that the data is Null.
