Home All Groups Group Topic Archive Search About

ASP.Net 2 Two Way Binding and DateTime Format Problem

Author
9 Jan 2006 4:11 PM
Ludovic DE FREITAS
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.

Author
9 Jan 2006 4:31 PM
Phillip Williams
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/aspnet20/GridView_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/aspnet20/GridView_2c.aspx

Show quoteHide quote
"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.

Bookmark and Share

Post Thread options