Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language

Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

TimeZone Information after Serialization


I am serializing a collection of objects of a Type(Class).
The class contians a DateTime type property in it.

Now, I am serializing this collection.
For some of the DateTime values, I get the DateTime with the TimeZone
Information included in the XML.
Like this   ...   2007-05-30T16:12:55.79239Z

Now, I dont want this in my XML, as it creates problem while converting this
value to datetime in SQL SERVER.

I an using .Net 2.0 and SQL Server 2005.

One of the the following to solutions is required.

1. The XML generated by serialization does not have the time zone
information with for the field.
2. Handling the conversion of a string representing this DateTime with
TimeZone information in SQL Server to convert it to SQL Date Time.

I need some solution for this urgently.


On May 30, 12:30 pm, "Sugandh Jain" <sugandh.j@nirvana-sol.com>

The best way to handle this is to solve the problem that is causing
timezone information to appear in your serialized data. I would do
this by tweaking the class definition.  For each datetime field, apply
the <XMLIgnore> attribute to it, and substitute a string-valued
property that retrieves/sets the datetime field correctly.
Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc