mike55 Posted October 13, 2006 Posted October 13, 2006 Hi I have a field in my database which stores a persons date of birth, its field type is datetime. When the user is submitting data, this field is optional. If the user does not submit data, then the default date of 01/01/1753 is inserted. My problem occurs when I want to export all the data in the table to a csv file. I fill my dataset as per normal, now for each row in the dataset I am checking if the date of birth column has the default date 01/01/1753. I do not want my users to see the above default date and I am instead trying to remove the data completely, but the column requires that I insert some sort of datetime. Can anyone recommend a possible solution? Mike55. Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
mike55 Posted October 13, 2006 Author Posted October 13, 2006 I used DbNull.Value Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.