I'm building an ASP web app that stores appointment times; it'll be used in different timezones. I'm currently saving an appointment in the database as a datetime field. Do I also need to add a field to save the timezone ? What's the best option to solve these multi-timezone issues?
View 1 RepliesI have a client side JavaScript that generates a date in JavaScript( new Date(2007,5,1)).
I need this date passed through to a hidden field that the code behind can access.
My issue is that when the hidden field is converted into a DotNet datetime, the time is incorrect. This is because the JavaScript is including timezone info from the client browser.
DotNet is then using this info to recalculate the time based on the difference between the server time and the client time.
What i need from the JavaScript is just the year, month and day.
I don't want to pass through 3 int values to my code behind as this will be a major change to the whole app.
What is the best way for me to accomplish this?
If i can set a UTC time with no timezone info I think that might work.
I have a custom user control which contains a asp hiddenfield object. The value of this hidden field is being set using javascript and I have verified that the value is being set properly. When a postback occurs the new value is not being saved and I cannot access it in my code.
I believe the problem is because the user control is not saved in viewstate and therefore the hidden field value is not saved accross postback. How can I make the hidden field save its value? I tried accessing it from the early page cycles and still no luck.
I have
byte[] a = HashEncrypt("a");
with
public byte[] HashEncrypt(string password)
{
SHA512Managed sha = new SHA512Managed();
byte[] hash = sha.ComputeHash(UnicodeEncoding.Unicode.GetBytes(password));
return hash;
}
I want to save byte[] a to my database. My database field is a varbinary(64). I'm using SQL Server 2008. I want to know the insert query with C# code. I am using ADO.NET
in my webapp I've created and populated a stringbuilder for a csv file. Normally I write it directly to the response object for the user to download through the browser.However, now I want to save it to a SQL DB image field. Is there a direct way to stream it in? Or do I have to save it to file first, then read it back in?
View 3 RepliesI use a ntext data type for all kind of data save in one field, but when i save byte (that converted from image) follwing message is shown "Operand type clash: varbinary(max) is incompatible with ntext". Is ntext suitable for all kind of data type or what will be compatible for all data type support?
View 2 RepliesI'm going to ask a user to login first, then when I'm going to save information I'm going to have to save the information and associate it with the logged in user.How should I handle this with session?
View 4 RepliesI try to construct a membership system using Walkthrough: Creating a Web Site with Membership and User Login. The membership system is going to be added to umbraco cms. I should admit that I am still in the learning process and need your guidance for my question.On my registration page other than standard fields which comes with CreateUserWizard, I need to add some extra fields in addition to that and those fields should be saved to database along with standard fields. Is it possible? If it is, how can I manage to do that?
View 3 Repliesi am facing the following problem while saving the viewstate on the server side using the savepagestatetopersistencemedium, but this is not working for the pages which contains update panel.
View 2 RepliesI am making a page that accepts post data from any number of pages that I cannot change, access, or in any way control.
I need, in one way or another, to get the timezone of the user. I know, ideally the posting page would do this, but I cannot access these pages.
First, there is javascript. I can get the javascript function to return (or change a label to) the correct value, but the problem is I need this info before the postback. I've been trying to write the timezone name on another page and read that page, but I have no idea how to begin to do that? Any other workaround to use the javascript is welcome, or any way to force call this before Page_Load is called?
[code]...
Basically, this works in debug mode, but when it's live only an empty string is returned. I am baffled? Is there any better way to read data from a page? I am using Request.ServerVariables["REMOTE_ADDR"] to get the ip, and that seems to be correct, since it inserts the correct ip into the database I'm using.
Here is the call:
GetTimezone(Request.ServerVariables["REMOTE_ADDR"]);
I have an ASP.NET web application that requires users to select their appropriate time zone so that it can correctly show local times for events.
In creating a simple approach for selecting the time zone, I started by just using the values from TimeZoneInfo.GetSystemTimeZones(), and showing that list.
The only problem with this is that since our application is primarily targeted at the United States, I'd like to show those entries first, basically starting with Eastern Time and working backwards (West) until I reach Atlantic time.
I want get timezone list to combo box. How can i get timezone list?
View 9 RepliesHow do I convert timezone from this format "03/03/2010 03:24:42 PM EST" to the current timezone in asp.net?
View 2 RepliesHow does TimeZone.CurrentTimeZone work if run in an ASP.NET app? Does it return the timezone of the application pool running the application? If using impersonation, does it return the timezone of the user its impersonating?
View 1 RepliesTo get the correct timezone of the user I get the offset first using javascript:-
var offset =new Date().getTimezoneOffset();
and then I apply assign the value to the server side variable.where I get the timezone using :-
ReadOnlyCollection<TimeZoneInfo> timeZones = TimeZoneInfo.GetSystemTimeZones();
foreach (TimeZoneInfo timeZone in timeZones)
{
[code]...
My Application hosted at server in time zone which differs from mine. All date in database is not correct for my time zone. How can I set my time zone for Application or how I can convert date to my time zone on output
View 1 RepliesHow do I write a timezone converter library in c#? or is there an existing timezone class I could use?
I will need the timezone database and be able to use it to calculate/convert from one UTC timezone to another timezone.
for some reason when I use the following code
TimeSpan timeDiffUtcServer = TimeZone.CurrentTimeZone.GetUtcOffset(DateTime.Now);
it returns -07:00:00 offset
I am using Windows XP and my timezone is set to Pacific time -08:00. I am running this through VS 2010's built in IIS server which is on my computer, so I can't figure out why the discrepancy in time.
I'm trying to write cookies from my website and I'm trying to figure out what implications timezones has over the HttpCookie.Expire property. Should I be passing DateTime.Now.AddDays(1) or DateTime.UtcNow.AddDays(1) or the users's timezone plus a day?
View 1 RepliesWhen a post is made to the site/database, it's made as Universal Time. A user can set the site's default timezone from a dropdown menu in the admin area, which saves the selected timezone to a database table (table: DefaultTimezone, column: Timezone). Now, how can I adjust the following code to display the datetime according to the correct timezone, that was set in the database? So if the Timezone column has "US Eastern Standard Time" in it, it would display the published datetime in that format.
<%#Eval("Published", "{0:MMM dd, yyyy - h:mm tt}") %>
If my user is in California and they have their computer set to PST, it's 1:00 pm there. If my server is set to EST, the current server time is 4:00 pm.
I need a way to get the timezone difference between the client and the server, either in Javascript or C#. In my example, I would get 3 (or -3, doesn't matter).
Does anyone know how to do this?
EDIT: Possible solution for RedFilter
Doing it all in javascript:
serverDate = new Date('<%= DateTime.Now.ToString() %>');
clientDate = new Date();
diffMin = (serverDate.getTime()-clientDate.getTime())*1000*60; //get difference in minutes
I need to find out the timezone of the country and i'm using VS2008. I have the following informations
Country name - India
start_boundary_latitude - 6:56N
end_boundary_latitude - 88:50N
start_boundary_Longtitude - 20:26E
end_boundary_Longtitude - 97:02E
ZoneStart - 82.30E
zoneEnd - 82.30E
I have above informations for all countries in my sql table. how to find the timezone for each with the above info. For exampl the timezone should be 5.5 for India.
I want to get clients Time Zone offset from his IP address for my web app. I have tried using Javascripts getTimezone function, but, some clients have their timezone or time set incorrectly. I want to get the offset and render some information back on client based on their timezone.
View 4 RepliesSuppose I have a string in U.S datetime format, "2/25/2010" and the server is on U.S East Coast with a timezone offset of "-5". When I convert the string via
Convert.ToDateTime("2/25/2010").ToUniversalTime(), it saved as "2/25/2010 5:00:00 AM" (which is correct as local server time for it is 2/25/2010 12:00:00 AM"
Now, suppose my user is in the U.S central time with a timezone offset of "-6", what I want to do is convert it approriately and when this user from central time do "Convert.ToDateTime("2/25/2010").ToUniversalTime()" type of statement, the datetime saved will be "2/25/2010 6:00:00 AM"
I want to change the server timezone to indian timezone in site
View 1 Replies