Monthly Archives: March 2014

await MessageDialog in the body of a catch clause

Posted on March 30, 2014 by LZH

A major disadvantage of using MessageDialog is that you need to await it to show the messagebox and when often you would need to display error messages in the catch clause. In normal situation you would be doing the below: … Continue reading →

Posted in C#, Windows Phone, winrt | Tagged , , , , | 5 Comments

Programming on the Toilet

Posted on March 25, 2014 by LZH

Originally posted on Eat. Sleep. Code.:
It’s 5PM. I’ve been working on the same code for hours, grinding out an implementation one line at a time. It’s been a torturous process. Some days, code just naturally flows from my brain…

Posted in Uncategorized | Leave a comment

Checking for Internet Connection

Posted on March 14, 2014 by LZH

In my previous post where I had shared about checking for Network Connectivity, NetworkInterface.GetIsNetworkAvailable(), however what the method is actually doing is to simple check for network connection and not necessary internet connection. There are situation where there is network … Continue reading →

Posted in C#, Windows Phone, winrt | Tagged , | Leave a comment

Additional text encountered after finished reading JSON content:

Posted on March 13, 2014 by LZH

When parsing through json you may encounter the error “Additional text encountered after finished reading JSON content:”. This is usually due to incorrect json syntax. One such example that result in the above error would be {“StaffID”:”S01″,”StaffRank”:”Manager”},{“StaffID”:”S02″,”StaffRank”:”Waiter”} Surrounding the above … Continue reading →

Posted in C#, Json | Tagged , , | Leave a comment

Free eBook: Location Intelligence for Windows Store apps

Posted on March 9, 2014 by LZH

Originally posted on Ricky's Microsoft Maps Blog:
I am happy to announce the release of my? book “Location Intelligence for Windows Store Apps”. This is available as a free eBook. Yes I said “free”, as in “Free beer”. Location…

Posted in Uncategorized | Leave a comment

VBA delete row if cell is empty

Posted on March 2, 2014 by LZH

The below code lets you find the last row and look into the range of cell if it is blanks. However there are instance where the lastrow might be error prone as this doesn’t tell you FOR SURE the last … Continue reading →

Posted in vba | Tagged , | Leave a comment

VBA Copy and Paste Cell as Value

Posted on March 2, 2014 by LZH

Here is how you can paste the selected data as value in Excel VBA. Below are the other possible paste special method in vba.

Posted in vba | Tagged , , , | Leave a comment