WCF Service
-
Hi All, I am using WCF service to retrieve the data from the Stored Procedure. In my resultant Dataset, I have a DateTime column . The value in this column is showing +11.30 Hrs when compared to Database . My Servers are in CST, and I am using IT timezone. Is there any setting am missing or any solution for this ? Thanks , Chaitanya.
-
Hi All, I am using WCF service to retrieve the data from the Stored Procedure. In my resultant Dataset, I have a DateTime column . The value in this column is showing +11.30 Hrs when compared to Database . My Servers are in CST, and I am using IT timezone. Is there any setting am missing or any solution for this ? Thanks , Chaitanya.
Hi All, I got the solution on googling.. the DateTimeMode of the DateTime Column in the Dataset should be set to DataSetDateTime.Unspecified. Code::
Dataset1.Tables[0].Columns["DateColumnName"].DateTimeMode = DataSetDateTime.Unspecified;