Posts

Showing posts from April, 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