Programming

You are currently browsing the articles from Information City matching the category Programming.

MSSQL: Concatenate a string with a NULL value

If the above scenarios occurs, the resulting output would be NULL/empty. To remedy such issue, ISNULL function can be used to replace the NULL value to an empty string like below:

ISNULL(fieldName,”)

Written by admin on March 10th, 2010 with no comments.
Read more articles on Knowledge Base and Programming.

Mobile device articles

Am involved to create a lightweight web application for mobile access, and found few articles around the net worth sharing:

1. http://mobiforge.com/developing/story/lightweight-device-detection-asp
2. http://woork.blogspot.com/2008/07/tips-to-design-your-site-for-mobile.html

Do you have any to share?

Written by admin on March 5th, 2010 with no comments.
Read more articles on Knowledge Base and Programming.

Visual Studio: Expand or Collapse Region or Code section

Been using it for a while and started to love the function. One colleague of mine asked me how I did it. Thought it would be worth a post over here:

Using Shortcut keys
Ctrl-M, Ctrl-O will collapse all of the code to its definitions.
Ctrl-M, Ctrl-L will expand all of the code (actually, this one toggles it).
Ctrl-M, Ctrl-M will expand or collapse a single region

P/S: The menus for expanding and collapsing code can also be found under Edit->Outlining

Written by admin on January 22nd, 2010 with no comments.
Read more articles on Knowledge Base and Personal and Programming.

« Older articles

No newer articles