Solved

Date field trouble in asp.net with Oracle sqldatasource

Posted on 2007-04-01
6
879 Views
Last Modified: 2008-01-09
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
Comment
Question by:talentium
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 7

Accepted Solution

by:
levyuk earned 200 total points
ID: 18831540
You should check the culture setting for the page/application/IIS and check that it is in english
0
 
LVL 27

Assisted Solution

by:sujith80
sujith80 earned 50 total points
ID: 18834241
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
 

Author Comment

by:talentium
ID: 18835024
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
Technology Partners: 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!

 
LVL 7

Expert Comment

by:levyuk
ID: 18837514
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
 
LVL 27

Expert Comment

by:sujith80
ID: 18841504
Sorry for the confusion,

dd-mon-yy - is a date format picture in Oracle. I am not sure about ASP.
0
 

Author Comment

by:talentium
ID: 18842049
thanks for your help
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question