Error Found: Expected type is DateTime (when merging dataset with typed dataset)

Posted by Thiru under VB.NET on 4/18/2012 | Points: 10 | Views : 3788 | Status : [Member] | Replies : 1
Hi,

I am getting this error: String was not recognized as a valid DateTime.Couldn't store <0000-00-00 00:00:00> in dob Column. Expected type is DateTime.
when i merge the normal dataset to typed dataset

Note:
dob filed is having this value 0000-00-00 00:00:00 in database.

using select query i am getting few records and dataset
and the same (dataset) is merged in Typed DataSet.
(When i merge the dataset to typed dataset i am getting the above error.

Note: as in typed dataset dob field type is datetime


expecting your valuable reply
regards,
Thiru.




Responses

Posted by: Dotnetrajanikanth on: 4/18/2012 [Member] Starter | Points: 25

Up
0
Down
This will help you

http://msdn.microsoft.com/en-us/library/esbykkzb%28v=vs.71%29.aspx

____________
www.flickr.com/photos/psdesigner/

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response