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

[RadhakrishnanR]

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