I am designing an ASP.net app for UK - so need the date format dd/mm/yyyy.
My development machine is setup for UK in control panel - and so is the registry (in as dd/mm/yyyy).
When I use
it outputs in dd/mm/yyyy format. When I go into sql server enterprise manager - it outputs in dd/mm/yyyy format.
When I attempt to run a ExecuteNonQuery on a sql server database however, it fails unless the date is in US format?!?!!?
So PLEASE if anyone knows why - help!
Firstly is there a quick workaround that will change the System.DateTime.Now.Date.ToString() date to US format - and secondly and more importantly - how can i get the ExecuteNonQuery to take UK date format?
I have been banging my head against a wall for days - any ideas?