DateTime saving problem from C# application..

[shaz jazz]

Hi! I have some problem relating saving datetime variable in SQL Server from C#.net application. i use Datetime.ToShortDateString() while sending parameter to Database. now the format of resulting string depends upon the regional settings of windows and SQL server takes M/dd/yyyy format or ISO format yyyymmdd. I want my application to be independent of regional settings. so i want whatever the regional setting is i should send to DB after converting to M/dd/yyyy format. For this purpose i wanted to override DateTime.ToShortDateString() but DateTime is a sealed class. So what should i Do??? any suggestions??

May God help u solv ur problems as well,thx in advance!!

[Giorgi Dalakishvili]

Call ToString() method and pass the format you wish. You may use CultureInfo..::.InvariantCulture Property[^]

#region signature my articles #endregion

[PIEBALDconsult]

Don't use a string, use a parameter.