Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 886
  • Last Modified:

Date field trouble in asp.net with Oracle sqldatasource

Hi,
I have some trouble working with date in asp.net and visual studio 2005.
I use a development environment at home with an oracle 8i server and iis5 from windows 2000 server
I create a page that use a sqldatasource to query the oracle database and to update
a row in the timesheet table.
I use the gridview to do so with an update command, the date field in the EditItemTemplate of my gridview is defined like this:
<EditItemTemplate>
 <asp:TextBox Width="60px" ID="TextBox1" runat="server" Font-Size="8pt" Text='<%# Bind("FORDATE", "{0:dd-MMM-yy}") %>'></asp:TextBox>
</EditItemTemplate>

All update are succefull and I well see the date like 01-mar-07 (The Oracle database need to receive date format in dd-MMM-yy to accept modification)

The strange thing is when I upload my work on the production server at the office, when I try to do the same update with the gridview, an error occured because the date displayed in my aspx page is not any more 01-mar-07 but 01-mars-07 (looks like french/belgium format).
If I rewrite the date field in 01-mar-07, the update is going ok; but if I leave it like displayed ->error 'not a valid month'

Would it be possible I need to change something on the IIS server at my office ?
or in the web.config ?

Thanks for your help
0
talentium
Asked:
talentium
  • 2
  • 2
  • 2
2 Solutions
 
levyukCommented:
You should check the culture setting for the page/application/IIS and check that it is in english
0
 
sujith80Commented:
dd-MMM-yy - is not a correct date format picture.

In order to get date in 01-mar-07 format: you should use dd-mon-yy picture
0
 
talentiumAuthor Commented:
I first try the culture settings on the IIS and get rid of my problem,
indeed the encoding was not the same on each server.

But as I am not an expert, I am also interested by sujith80 comment, actually
I use dd-MMM-yy and it works lika a charm, should I change to dd-mon-yy ?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
levyukCommented:
To be honest talentium I've never seen dd-mon-yy in asp.net, i think it's to do with oracle not ASP.net so you wouldn't need it in your page, I would stick with what you know and what works
0
 
sujith80Commented:
Sorry for the confusion,

dd-mon-yy - is a date format picture in Oracle. I am not sure about ASP.
0
 
talentiumAuthor Commented:
thanks for your help
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now