Posts

Showing posts from 2009

a simple way to manipulate data using sql

public static DataTable ExecuteSQL(string sql, Dictionary parameters) { DataTable dt = new DataTable("DataTable"); using (SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ipropertydb_localConnectionString"].ConnectionString)) { myConnection.Open(); SqlCommand mySqlCommand = new SqlCommand(sql, myConnection); if (parameters != null) { foreach (KeyValuePair p in parameters) { mySqlCommand.Parameters.AddWithValue(p.Key, p.Value); } } using (SqlDataReader datareader = mySqlCommand.ExecuteReader()) { dt.Load(datareader); } } return dt; }

Why choose Windows Mobile 6.0 or higher?

Why choose a phone powered by Microsoft Windows Mobile? The reason is because there are so many useful software which can be run in WM phone, and therefore increase the usability of the phone itself. In returns, you will be more productive. A normal WM phone requires 128RAM and 500Mhz processor to run smoothly. This specification is equivalent to a desktop PC 10 years ago. Now it is only less than 150g weight and you can carry by putting into your pocket. WM phone or known as smartphone of today is fully packed with interesting features such as GPS, Wifi, Bluetooth, GSM and 3G. Because the data communication is so rich and with internet access, you will get any information you can think of anywhere. Just open your device and locate where you are and get direction to the nearest coffee shop. Or use IM to connect to your friends Cool? You might be asking, non WM phone does have those features like GPS, Wifi and ect. But do you know that, WM have a lot of great software to try it out beca...

KTM please improve your service!

I am quite sad that nowadays KTM do not keep up with it services. I feel am wasting my time keep waiting a train that always late and full of technical problems. I think KTM need to upgrade it service and keep up to serve us.

Installing PHP, MySQL and Apache for lazy pro

Are u experiencing difficulties in configuring PHP, MySQL and Apache? Or do u want a fully automatic way to install these at once or simply just to avoid any hassle to install these programs? Here is the best single installation, after installed everything will be working fine. http://www.wampserver.com/en/ One thing that I really like about this author is that he really keep everything updated with the latest version available in the setup file. Thanks

.NET date String format

' This code produces the following output. ' ' ALL the patterns: ' [0]: MM/dd/yyyy ' [1]: dddd, dd MMMM yyyy ' [2]: dddd, dd MMMM yyyy HH:mm ' [3]: dddd, dd MMMM yyyy hh:mm tt ' [4]: dddd, dd MMMM yyyy H:mm ' [5]: dddd, dd MMMM yyyy h:mm tt ' [6]: dddd, dd MMMM yyyy HH:mm:ss ' [7]: MM/dd/yyyy HH:mm ' [8]: MM/dd/yyyy hh:mm tt ' [9]: MM/dd/yyyy H:mm ' [10]: MM/dd/yyyy h:mm tt ' [11]: MM/dd/yyyy HH:mm:ss ' [12]: MMMM dd ' [13]: MMMM dd ' [14]: ddd, dd MMM yyyy HH':'mm':'ss 'GMT' ' [15]: ddd, dd MMM yyyy HH':'mm':'ss 'GMT' ' [16]: yyyy'-'MM'-'dd'T'HH':'mm':'ss ' [17]: HH:mm ' [18]: hh:mm tt ' [19]: H:mm ' [20]: h:mm tt ' [21]: HH:mm:ss ' [22]: yyyy'-'MM'-'dd HH':'mm':'ss'Z' ' [23]: dddd, dd MMMM yyyy HH:mm:ss ' [24]: yyyy MMMM ' [25]: yyyy MMMM '...

Krabi - Some photo taken in day 2

Image

Travel to Krabi - Arrival - 4 Jan 2009

Image
A year ago, my friend nova invited me to join him for a trip to Krabi, Thailand. That time, I have no idea where is Krabi and what is hot there. Well according to wikipedia, " Krabi ( Thai : กระบี่ ) is a town ( thesaban mueang ) on the west coast of southern Thailand at the mouth of the Krabi River into the Andaman Sea . As of 2005 the town has a population of 24,986. The town is the capital of Krabi Province and Krabi district ." We were planning to take Airasia flight from Kuala Lumpur to Krabi and it only cost us less than RM300 for both way. Acutally quite value for this trip visiting the best Phi Phi islands which is 3 hours from Phuket, Thailand. On Sunday 4th Jan 2008, I arrived to Krabi and we went to Ao Nang. Ao Nang is located beside the beaches and you will find this is the place the most happening whould be. A lot of fun pubs, restaurants, massage centeres, travel agencies, 7-Eleven, McDonals, Starbucks, Haagen-Dazs, and etc are all here. I was shock because ...