HINT: DO NOT USE DYNAMIC SQL. PERIOD. JESUS CHRIST IS IT 2009 OR 1999 HERE? SQL INJECTION FRIGGIN' CITY.
I know that a) that's not what you asked and b) may not even apply directly to the code in question, but if you're using dynamic SQL at all, anwhere, in the least bit, it means you're using it too much. More relevant hint: when CurrentCulture is autodetected, or set, you shouldn't have to manually convert dates. They UI thread should handle formats and timezones for you. Another relevant hint: let autodetection work for you! User's browsers should indicate language and timezone to the server automagically, you shouldn't have to determine that manually the way you're doing. ∞ Andy Badera ∞ +1 518-641-1280 ∞ This email is: [ ] bloggable [x] ask first [ ] private ∞ Google me: http://www.google.com/search?q=andrew%20badera On Thu, Sep 17, 2009 at 4:56 AM, Jay <[email protected]> wrote: > > Hello All, > > I have a requirement let me know if it is possible. There will be a > web application which will be accessed by users from different > countries. No matter where the user is accessing from I will be saving > the dates in utc format as an example > > strSQL = "Insert into emp(joindate)values > ('"+DateTime.Now.ToUniversalTime()+"');"; > Now at the time of retrieving the dates I have to show the dates > depending on the timezone of the user accessing the web page. > For that I have used the following code segment > > Response.Write(Convert.ToDateTime(reader["joindate"].ToString > (),Thread.CurrentThread.CurrentCulture.DateTimeFormat) + "<br>"); > > Following is the code segment which I have have used in the > Global.asax.cs Application_BeginRequest to retrieve the first language > from browser language list. > > HttpRequest request = HttpContext.Current.Request; > if (request.UserLanguages == null) return; > string language = request.UserLanguages[0]; > if (language != null) > { > if (language.Length < 3) > { > language = language + "-" + language.ToUpper(); > } > Thread.CurrentThread.CurrentUICulture = new CultureInfo > (language); > Thread.CurrentThread.CurrentCulture = new CultureInfo > (language); > } > I have added new language from languages add option (internet > explorer) for example French (France) [fr-FR]. Now when the date is > rendering it is formatted with the code page, but is there any way to > automatically increment /decrement the date time detecting the > timezone the user is accessing the web page? One way it could be done > I can explicitly mention the time zone and add / subtract the time > difference. > > Please let me know if you have any hint. >
