ASP .Net Form Authentication mode setting in Webconfig

<authentication mode="Forms"&gt

<forms defaultUrl="Default.aspx" loginUrl="Login.aspx" protection="All" timeout="180"&gt</forms&gt

</authentication&gt

<authorization&gt

<deny users="?"/&gt

</authorization&gt

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!