The solution lies in using the UpdateParameters collection to cast the
TextBox's date string format to an internal DateTime type.
If I build a web page that allows the user’s browser to determine the
display of the date, yet my database operates on a server using the culture
setting for en-us, then I would get an error that "Cannot convert value of
parameter 'OrderDate' from 'System.String' to 'System.DateTime' ":
http://www.webswapp.com/CodeSamples/..._2c_error.aspx
If I add an UpdateParameters section within my objectDataSource defintion to
explicitly cast the edited values to their appropriate date type, I do not
get that error as in this demo:
http://www.webswapp.com/CodeSamples/...idView_2c.aspx
--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Ludovic DE FREITAS" wrote:
> Hello,
>
> I have a ASP.Net page where I use the new two-way binding.
> Unfortunatly the Update have problem with DateTime format.
>
> I use a TextBox : <asp:TextBox runat="server" id="tbDate" Text='<%#
> Bind("MyDate","{0:dd/MM/yyyy}") %>
>
> The Binding (display) works, but the Update use another format "MM/dd/yyyy".
> I have try to change the Thread Culture, the browser culture, the server
> regional settings and nothing works.
> I have check the UpdateItem with Reflector in FormView class, ans It seems
> that the InvariantCulture is used to convert string to DateTime !!!
>
> Can anyone help me with this problem ?
>
> Thanks.