GridView in ASP.net using wrong date format MM/DD/YYYY instead of DD/MM/YYYY
<p>I have a GridView in ASP.net which is filled from an SqlDataSource. </p>

<p>one of the columns in the DB table is a Datetime which is set to 30/04/2009, when i show the grid view in asp it appears as 30/04/2009.(which is fine)</p>

<p>however when I hit edit on the row in the grid view, and then hit update without changing the date I get an SQL error which says essentially that the date format is wrong. This is because it thinks that the 30 is refering to the month rather than the day.</p>

<p>I have tried resolving this by setting the &lt;%@ Page uiCulture="en-gb" culture="en-gb" %></p>

<p>but with no effect.</p>

<p>any ideas?</p>
