By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,192 Members | 1,248 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,192 IT Pros & Developers. It's quick & easy.

I have problem in Date format in C# .NET 1.1

P: 15
HI ALL,

My .NET application devloped in C# used mainly class file (OOAD) and user controls etc and it is desktop application not web based application. Database is SQL server 2000.

Now I have problem in Date format.

Scenario is :
If my application is running in the following setup, i.e The SQL server2000 is installed with DDMMY format and system setting also DDMMYY.
Now when the user enters the date like 19-04-2007 in the UI,it is generating error (Erro msg is : The conversion of char dat type to smalldatetime data type resulted in an out of range small datetime value.)

BUT If the PC set up is in MMDDYY format and SQL server too then no problem. i.e Application will allow/Fetch the record when the user enter date like 19-04-2007.

Brief about Architecture: My Application has four tier architecture. i.e Presentation, Business Facade (Remoting used here to call Business service), Business service (BS), Datatransfer.

This .NET application is generalised application,Means it is not for any specific country. So I need best way to fix this problem.

Please help me out to solve this problem. Thank you so much....


Thanks
Radhakrishnan.R
Apr 21 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.