DataSet DateTime Binding Issue
-
I have sql (sql server 2005) table which is having StartDate and EndDate datetime columns.
StartDate value inserting as 2009-08-11 00:00:00.000,
EndDate value inserting as 2009-08-11 23:59:00.000 (End of the dayThis DB Server is located at london. in my winforms(2.0) appliction i have typed dataset, is having same table schema. Typeddatasset StartDate and EndDate DateTimeMode property set to UnspecifiedLocal. i am populating this dataset with SP. SP is functioning properly. returned data i am binding to DataGridView. when its biinding to datagridview,
StartDate is showing as '8/11/2009 4:30 AM' instead of '8/11/2009 12:00 AM' and
EndDate is showing as '8/12/2009 4:29 AM' instead of '8/11/2009 11:59 PM'it seems problem is with databinding to dataset. any sounds?
Ramana
-
I have sql (sql server 2005) table which is having StartDate and EndDate datetime columns.
StartDate value inserting as 2009-08-11 00:00:00.000,
EndDate value inserting as 2009-08-11 23:59:00.000 (End of the dayThis DB Server is located at london. in my winforms(2.0) appliction i have typed dataset, is having same table schema. Typeddatasset StartDate and EndDate DateTimeMode property set to UnspecifiedLocal. i am populating this dataset with SP. SP is functioning properly. returned data i am binding to DataGridView. when its biinding to datagridview,
StartDate is showing as '8/11/2009 4:30 AM' instead of '8/11/2009 12:00 AM' and
EndDate is showing as '8/12/2009 4:29 AM' instead of '8/11/2009 11:59 PM'it seems problem is with databinding to dataset. any sounds?
Ramana
Please do not attempt to bump your posts. Very rude!! It is only 5 hours since your previous post. Have a little patience!!! Whilst your problem is obviously urgent to you, we give our time on a voluntary basis. Therefore your need is greater than ours and if your need is so great I suggest thet you get your Credit Card out and visit rentacoder.com. :)
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”