Saturday, August 13, 2011

Regional settings IIS6 and ASP.Net 2

Issue
1. {0:c} returning too many decimals in gridview
2. {0:d dd/MM/yyyy} returning date with time values
Ex: 12/12/2012 00:00:00

Solution
I solved this problem by installing service pack 2 of ASP.Net 2.0 - after the reboot, the grid worked fine with {0:C} and {0:d}
This problem would have fixed itself in the production environment as it will be set to update automatically. Recently I got the new machine and the firewall seems to be restricting the updates.


Lesson learned: always make sure that all your server software is up to date!