ASP.Net 2 Two Way Binding and DateTime Format Problem

  • Thread starter Ludovic DE FREITAS
  • Start date
L

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.
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,906
Latest member
SkinfixSkintag

Latest Threads

Top