thanks for the link Andrew ,
your answer does definetly help and that is how i am going to handle this
issue with the datetime conversion. so basically the idea is to have client
side code which add an extended property to the dataset in which it stores
the information that is then used to calcualte the client side datetime on
the server.
To minimize the client side coding to add this extended property to the
dataset before it is being send across the webservice( i am having 100s of
calls to webservice all over the application and adding this code to each
call might take a long time) i am thinking if it is possible to write this
code at a central place where it can be read by all datasets gong out of the
webservice.
Below are the details :
overwrite the client side webservice;s proxy's GetWebRequest method which
would give me access to the request object and then somehow check to see if
it has a dataset object within it and if it does then add this extended
property to it and then send it out. And a similiar thing on the client side
for incomming datasets in which case i woudl want to overwrite the
webservice;s proxy's GetWebResponse method and convert the datetime using the
dataset;s extended property which was added to it by the server side code.
As far as code for the server side, i think i can easily write it for all
the methods so no concern over there.
Any body any clue on this one, please suggest!
thanks
"Andrew" wrote:
> read this article ...see if this help you
> http://support.microsoft.com/kb/842545/en-us
>
> "sameer" wrote:
>
> > Environment : framework 1.1, winforms, webservices, sql server 2000
> >
> > Architecture of the application : database is hosted behind the webserver.
> > Client winforms application is installed on the client machine and webservice
> > are used to transfer the data from the client exe to the database over the
> > internet. Database\ webserver server is running on GMT time where as the
> > client machines can be running on any time zone. Ado.Net Datasets are used to
> > transfer the data between the client machine to the database over the
> > webservice.
> >
> > Here is my problem :
> > Lets say client EXE is running on a machine that has Eastern time zone, user
> > modifies a date which is now '6/23/2007 4:20:30', this modifications along
> > with the others mdifications user has done are put in a dataset and send
> > across the webservice to the database( where the timezone is different and is
> > GMT), so here is the problem, seems when the webservice gets this dataset it
> > automatically converts the datetime from Easter to GMT and saves it to the db
> > i.e the new datatime is '6/22/2007 11:20:30' ( 5 hrs behind of the easter). I
> > want the same date that the user selects to be saved in the database without
> > any conversions. Any suggestions on how i can do this? the client exes can be
> > running on all different timezone worldwide
> >
> > Please suggest.
> >
> > thanks
Similar Threads
